Where are the job schedules stored ? same for the job schedules results ?

[vloiseau]

Hi,

This is a question for snapcreator 3.5.0

- Is there a way to see or have all the results in text form ?

- How the results are refreshed and obtained from ? Sometimes customers have to restart the snapcreator server service to refresh the job schedule result ?

Thanks.

Valéry.

[Arora_Kapil · Accepted solution]

The schedules and their results are stores in the database.

The scheduler runs as part of the Snap Creator server, you don't need to restart the server to refresh the scheduler or its results.

Once the job is complete the database is updated and you can check that in the SC GUI.

There is no direct way, if you like we can give you steps to import them into a file from the database.

Thanks,

Kapil

[vloiseau]

Yes I would like to have the possibility to export and import this schedules in case of SC server or platform upgrade.

Thanks.

[charly]

Can you please share the use case for this..? You want to take the backup of configured schedules or want to replicate this to some other snapcreator server..?

regards

[vloiseau]

Hi,

We have a problem sometimes with the entry in this schedule database, some schedules seems active but never launch the job until we modify the Start Time, like modifying the schedule entry is activating something...

[vloiseau]

The use case is a deploy new domino (or other application) servers and other application and you want to schedule backup for it in a industrial manner.

[Arora_Kapil]

Steps to import scheduler records

1) Move to snapcreator gui directory

2) Set classpath to locate derby.jar and derbytools.jar they are under gui/lib/

gui> set classpath=path/to/derby.jar; path/to/derbytools.jar

3) run ij with following command:

gui> java org.apache.derby.tools.ij

4) set snapcreator schema

ij> SET SCHEMA SNAPCREATOR;

5) run query to select all records:

ij> SELECT * FROM TASKS;

7) If you would like to import the table to a ‘tasks.de1’file, here is the command:

ij> CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE

   (null,'TASKS','tasks.de1',null,null,null);

[brauntvr2swiss]

Hi Valéry

We have the same Issue with Jobs(some schedules seems active but never launch the job until we modify)... In the meantime, do you have found a solution for this?

TIA

Thomas

[haenggi]

Hi Thomas

There is a Patch Release of SnapCreator 3.6 available (SC 3.6p1) http://support.netapp.com/NOW/download/software/snapcreator_framework/3.6P1/

In this Patch Release your Bug is fixed.

Date Posted: 01-OCT-2012

Snap Creator Framework - 3.6P1
Based on Snap Creator Framework 3.6 


BURTs addressed in this release
===============================


622192 -- Snap Creator scheduling: If the start date is in the past relative to the current date, then schedule will no longer run.

624659 -- The new configuration wizard does not detect Cluster-Mode SnapMirror relationship.

630022 -- Snap Creator schedules do not run based on schedule.

631734 -- In Snap Creator GUI few options are disabled when advanced options is selected.

631132 -- Documentation issue: The Installation and Administration guide says the default port for OM_PORT is 8080 instead of 8088 or 8488.

610551 -- Documentation issue: The Installation and Administration guide lacks instructions to restart Snap Creator service.

I have already installed it successfully at a customer.

Cheers Michael

[ktenzer]

Hi Thomas,

This is because of a bug which was fixed in SC 3.6p1 please download and upgrade to 3.6p1.

http://support.netapp.com/NOW/download/software/snapcreator_framework/3.6P1/

Regards,

Keith

[brauntvr2swiss]

Thanks for your answers, but we have had Problems after the Upgrade to 3.6. --> See following Thread. In the Moment we have installed 3.5 again...

So I have to open a Case with the Problem "SC 3.6 and PM Integration" and after fixing this I have to upgrade to 3.6p1 to resolve the Scheduler Issue.

Thanks

Thomas