DSXchange

Hi All,
I want to know how to automate the datastage jobs on Windows environment.Right now we don't have any scheduling tool and we are implementing the Datastage first time. If datastage scheduling is not flexible please let me know which scheduling tools we can use for datastage jobs on windows environment.

1. I have to watch for a file to kickoff the datastage job. Can some please let me know how to achieve using the datastage scheduler?

Thanks
Ravi

DataStage does not come with any scheduler, per se. Instead it comes with an interface to the standard scheduling tool on your platform - for UNIX that is 'cron' and 'at' while on Windows it leverages 'at'. Now you can use pretty much any scheduling tool you like, something like Control-M (for example) can make use of the command line API to schedule and run whatever you like.

As to your 'watch for a file' question, the simplest answer would be a Sequence job that starts from a Wait For File stage. Then you can use triggers to control what happens with the file does (or does not) show up, be it run a job, send an email, whatever.

i think control-M give more flexible scheduling

chulett wrote:DataStage does not come with any scheduler, per se. Instead it comes with an interface to the standard scheduling tool on your platform - for UNIX that is 'cron' and 'at' while on Windows it le ...

For Schduling purpose we have one tool i.e Contro -M Tool that is one option and second option is we need to schedule in datastage director it self.

If "watch for a file to kickoff the datastage job" is your requirement, then you don't have to think on a "scheduler" line. Wait for file stage in the sequence will do this for you.

snt_ds wrote: I have to watch for a file to kickoff the datastage job. Can some please let me know how to achieve using the datastage scheduler?