Starting a Job

[mkeevil]

Does anyone know if it is posible to start a DataStage Extraction job, from a differnt system? Example.... having a Java program execute an extraction when the Java program is called. I want to make the job event driven and not Date/Time Driven?[?]

[chulett]

Check in your documentation for the 'Command Line Interface' topic. It's typically near the end of the Server Job Developer's Guide and allows external processes to run DataStage jobs.

Specifically, the 'dsjob' command.

-craig

[kduke]

mkeevil

Craig is refering to dsjob but you need to watch it if 2 processes can start the same job at the same time. It is my understanding that there exists a real time solution in the latest release.

Kim.

Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com

[vmcburney]

The two methods currently are to have a job running in a sleep and check loop waiting for a particular database flag or file or to fire off the job using the dsjob command line commands. The first option gives DataStage control over when the job runs, with the second option you've got to ensure the job is not already running and is runnable.

There is a "WaitforFile" stage available for sequential jobs, which you can copy and use in Batch Jobs, this lets you trigger the job by writing a file to a particular folder.

DataStage 7 does have real time services which can be called up using java however like parallel extender it is an optional extra that you have to pay for.

Vincent McBurney
Data Integration Services
www.intramatix.com

[ray.wurlod]

Since Kim was cool enough not to do any self-promotion, let me also suggest DSWebMon (from Duke Consulting, Inc).
Visit http://www.duke-consulting.com/P1_DsWebMon_Main.htm for more information.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518