Data stage job triggered by event

berettae · Post by **berettae** » Tue Jan 21, 2003 12:06 pm

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

chulett · Post by **chulett** » Tue Jan 21, 2003 12:29 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Jan 21, 2003 4:12 pm

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

amaruvi · Post by **amaruvi** » Tue Jan 21, 2003 11:16 pm

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