Page 1 of 1
Data stage job triggered by event
Posted: Tue Jan 21, 2003 12:06 pm
by berettae
We need to launch a job (Data Stage XE 5.1, UX)when a certain event occurs.
Scheduling features don't seem to be a solution since jobs can be scheduled waiting for an event to happen (eg. file trasmission), but we don't know how to automatically reschedule jobs after the first execution.
Anybody has some suggestion?
Thanks,
Enrico
Posted: Tue Jan 21, 2003 12:29 pm
by chulett
Look in your 'DataStage Server Job Developer's Guide'. Near the back (Chapter 14?) there is a section documenting the 'Command Line Interface' which your triggering event can use to launch DataStage jobs.
-craig
Posted: Tue Jan 21, 2003 4:12 pm
by ray.wurlod
You need to think this through VERY CAREFULLY.
Is the event likely to occur twice in close succession? What do you propose should happen if the first start is still running when you want the second start to occur?
DataStage is not really intended to be event driven. The preferred approach is to have the event cause something else to happen, such as the creation or deletion of a file or flag value, which a regular batch run of DataStage can detect.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Posted: Tue Jan 21, 2003 11:16 pm
by amaruvi
Make the event ptogram change a flag in a table or file. While runiing the job, ensure that the job checks for the flag value. If the flag is set then go ahead with the job and reset the flag after the job is over.
You can also put to use the Job Sequencer for this purpose.
Amaruvi