Page 1 of 2

datastage scheduler

Posted: Tue Dec 30, 2008 6:25 pm
by Nagaraj
I have scheduled the jobs in the director, Is there any way i can get this schedule information outside datastage?

Posted: Tue Dec 30, 2008 6:33 pm
by mandyli
Is there any way i can get this schedule information outside datastage?
What kind of schedule you need? B'cus different kind of schedule is there.

please post clearly.

Posted: Tue Dec 30, 2008 6:38 pm
by Nagaraj
i said i need to get the schedule information.
for example: i need to knw when a particular job is scheduled to run, at what time and on which day etc etc

hope this is clear.

Posted: Tue Dec 30, 2008 6:40 pm
by Nagaraj
i said i need to get the schedule information.
for example: i need to knw when a particular job is scheduled to run, at what time and on which day etc etc

hope this is clear.

Posted: Tue Dec 30, 2008 6:43 pm
by chulett
DataStage doesn't include a "scheduler" so leverages the underlying O/S. For UNIX that means cron and a check of the crontab entries for the scheduling user will have what you need.

Posted: Tue Dec 30, 2008 7:03 pm
by Nagaraj
if i schedule the jobs thru director, where else i can find that information

Posted: Tue Dec 30, 2008 7:58 pm
by ray.wurlod
In Director Schedule view or through inspecting the crontab entries for the DataStage user.

Posted: Tue Dec 30, 2008 8:30 pm
by veera24
ray.wurlod wrote:In Director Schedule view or through inspecting the crontab entries for the DataStage user. ...
Could you pls. explain about 'crontab' entries for DS user?I'm not aware of it. Jus wanted to know in detail thats why.

Thanks,
Veera

Posted: Tue Dec 30, 2008 8:34 pm
by Nagaraj
ray.wurlod wrote:In Director Schedule view or through inspecting the crontab entries for the DataStage user.
Meaning if i schedule the job in datastage director, automatically it willl appear in the crontab entry?

Posted: Tue Dec 30, 2008 8:51 pm
by chulett
If you are unfamiliar with cron on UNIX systems, perhaps a chat with your SysAdmin is in order. From the operating system command line, logged in as the scheduling user, a "crontab -l" will list all of the scheduled items for that user.

It will look a little cryptic if you've never seen it before but there are references easily found out there in the wild. For example:

http://en.wikipedia.org/wiki/Cron#crontab_syntax

Posted: Tue Dec 30, 2008 8:57 pm
by Nagaraj
No i know what a crontab is,but i didnt know that if i schedule the job in datastage director and i can see an entry in the cron.

thanks for your information. will check it and put the topic resolved.

Posted: Tue Dec 30, 2008 9:00 pm
by chulett
For completeness, DataStage leverages cron for recurring schedules and at for 'one off' schedules - so you may need to check both to see everything.

Posted: Tue Dec 30, 2008 9:04 pm
by Nagaraj
chulett wrote:For completeness, DataStage leverages cron for recurring schedules and at for 'one off' schedules - so you may need to check both to see everything.
Yes this is what striked me to ask this question, what is AT? windows scheduler? i assumed that if we schedule jobs in datastage director then we need to check in at, not on cron....

i suppose i was wrong.

Posted: Tue Dec 30, 2008 9:56 pm
by Nagaraj
yes i got what AT is...thanks...

Posted: Tue Dec 30, 2008 10:13 pm
by Nagaraj
Nagaraj wrote:yes i got what AT is...thanks...
The information about the AT command is at the link with an example

please have a look

http://news.softpedia.com/news/Windows- ... 3404.shtml