Datastage job need to run hourly schedule

[cnu]

Hi:

I want to run the datastage job hourly basis from 9AM to 6PM from Monday to friday.Source is the Pipe separated flat file and source is the Saolserver database.

How can i approach this requirement,please let me know.

Thanks
cnu

[chulett]

'Add to Schedule' once per hour during those times. Or build job control that runs the job in a loop and sleeps until the hour arrives, exiting after the 6PM run.

[cnu]

Hi:

Please let me know the approach for scheduling job.
Through autosys or datastage director,what is the best approach or is there any way to achieve the requirement.

Thanks
Sreeni

[chulett]

The 'Add to Schedule' reference was for DataStage Director if you are allowed to use it. Or just do the same for AutoSys, schedule the job to run once per hour during your window.

[cnu]

Hi :

Thanks Craig Hulett !!

From director how can i specify the time 9AM to 6PM from Monday to friday.

Please can you let me know the steps.

Thanks
cnu

[ArndW]

Explicity enter one start each at 9am, 10am, 11am, etc.

[chulett]

From Director:

1. Select job
2. Add to Schedule (right-click or clock icon)
3. Select the 'Every' radio button
4. Make sure Monday thru Friday are highlighted
5. Set time to 9:00 AM
6. Click OK
7. Set parameters
8. Click Schedule

Repeat for 10AM, 11AM, etc etc up to 6PM.

[cnu]

Craig Hulett :

Thank you so much.

Thanks
cnu

[chulett]

np. Just make sure you recognize the potential problem with this approach - can you guarantee your job will always complete in less than an hour? If not, then any overlapping schedule will fail to start. Also note that, unless we are talking about a restartable sequence job here, that a failed job will need to be manually reset before it can be run again.

If your post is now resolved, please mark it that way!

[cnu]

Hi Craig Hulett :

For the scheduling Job from the director cron and cron tab is required right?

Thanks
cnu

[chulett]

You marked your post as 'Windows' meaning a Windows server installation. If indeed you are on UNIX, then yes - your scheduling user will need access to both "cron" and "at" (assuming both repeating and one-time schedules are needed) and you'll need to talk to a SysAdmin to arrange inclusion in both "allow" files.