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 job scheduling on Windows environment
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Use Cotrol M toll
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.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 ...
sivaram
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Re: Datastage job scheduling on Windows environment
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?
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>