Back up scheduling details of scheduled tasks

Nisusmage · Post by **Nisusmage** » Wed Oct 15, 2008 5:43 am

Is it possible to backup the scheduling details of scheduled tasks?

We are busy moving DS to another server/DB and need to reinstate the scheduling details of scheduled jobs on the new installation.

Alternatively, can I find the schedulling details in the DB?
If so, where?

We are running on SQL2005

Thanks

chulett · Post by **chulett** » Wed Oct 15, 2008 8:36 am

"Scheduling" as in via the DataStage Director? They're not in your database, they are stored in Window's "at" system. So I would google around and see how one would dump the "at" schedule on one machine and load it on another.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 15, 2008 2:55 pm

Is that still true in version 8, or does an Information Server scheduling service get involved? (I don't currently have access to version 8 to check.)

chulett · Post by **chulett** » Wed Oct 15, 2008 2:58 pm

Good question, didn't notice the dreaded "8" for the version number. Does this work differently now?

ArndW · Post by **ArndW** » Thu Oct 16, 2008 6:08 am

DS still uses "cron" & "at" at version 8.