Page 1 of 1

Export schedules

Posted: Thu Jul 20, 2006 2:01 pm
by Juls
HI,

My project is corrupted to a point that a REINDEX does not help and DS support tried every command possible to help, but without a result.

So I decided to maybe create a new project and import all the good jobs in.
I have a lot of schedules for different jobs in this project and do not really want to manually recreate them in new project.

Is there a way to save the schedule and then copy into new project? Maybe some DS internal file?....

Thanks,
Juls

Posted: Thu Jul 20, 2006 2:29 pm
by Amos.Rosmarin
Hi

If you are working on a Windows server, you can see all your scheduled tasks in the windows control panel --> Scheduled tasks

I guess you can find them all somwhere in the registry :roll:


HTH,
Amos

Posted: Thu Jul 20, 2006 2:31 pm
by DSguru2B
All your schedules are stored using ControlM scheduling utitlity.
You will need to do a little research to find how and where the schedules are stored in unix.
Or someone might know the solution here.

Posted: Thu Jul 20, 2006 2:36 pm
by chulett
DSguru2B wrote:All your schedules are stored using ControlM scheduling utitlity.
And you know this how? :?

UNIX 'schedules' - assuming standard Director scheduling - are stored in the crontab of the scheduling user for recurring jobs. However, seeing as how the OP is on Windows, that doesn't really help all that much.

Posted: Thu Jul 20, 2006 2:46 pm
by Juls
I thought tthat schedules are stored somewhere in DS files like it stores environment variables and list of jobs, etc...

Posted: Thu Jul 20, 2006 2:54 pm
by chulett
No, they are stored in whatever mechanism is doing the scheduling - cron, at, Control-M, etc. DataStage has no scheduler built in, only an interface to the external schedulers of choice: cron/at on UNIX and at in Windows. So, depending on your scheduler and O/S it would just be a matter of educating it that your jobs live in a new project now.

I'm sure people would pony up more specific advice if you confirmed what scheduler you were using...

Posted: Thu Jul 20, 2006 3:10 pm
by Juls
I am running on Windows and using AT scheduler.

What if I delete my current project and create a new one with the same name, import the jobs. Would the schedules still be valid? or will they be deleted from AT when I delete project?

Posted: Thu Jul 20, 2006 3:18 pm
by chulett
They should still be fine, I would think. Don't know with 100% certainty as I'm not running a Windows server, but...

Posted: Thu Jul 20, 2006 6:25 pm
by ray.wurlod
They will still be in the AT scheduler (open a CMD shell and execute the AT command alone in order to see them). However, they are probably still pointing at the old project, so may not work.

Posted: Thu Jul 20, 2006 7:00 pm
by chulett
Juls is planning on deleting the problem project and recreating it with the same name. In that case, it sounds like they will be fine.