Datastage job scheduling on Windows environment

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
snt_ds
Premium Member
Premium Member
Posts: 280
Joined: Wed Oct 18, 2006 11:53 am
Location: Pune, India

Datastage job scheduling on Windows environment

Post by snt_ds »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

i think control-M give more flexible scheduling
siva.k82
Participant
Posts: 7
Joined: Thu Sep 14, 2006 10:57 pm
Location: marthalli
Contact:

Use Cotrol M toll

Post by siva.k82 »

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.
sivaram
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Re: Datastage job scheduling on Windows environment

Post by JoshGeorge »

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>
Post Reply