Guest

• Jul 14th, 2006

 

Controlling Datstage jobs through some other Datastage jobs. Ex: Consider two Jobs XXX and YYY. The Job YYY can be executed from Job XXX by using Datastage macros in Routines.

To Execute one job from other job, following steps needs to be followed in Routines.

1. Attach job using DSAttachjob function.

2. Run the other job using DSRunjob function

3. Stop the job using DSStopJob function

Thanks,

Vimal T

mcrao1

 Profile Answers by mcrao1 

• Oct 20th, 2010

 

Control table perform a small verification before running job, Control table will help avoid running query number of times when we are expecting to run single time in a day. Control table contains fields like JOBID,JOB_NAME,PREVIESE_RUN_DATE,


Thank you.
-chalapathirao.m AT hcl DOT com