To pass job status to routine

kduke · Post by **kduke** » Tue Jul 29, 2003 11:07 am

Massimiliano

You need to check this in a controlling job. You cannot check the status in an after routine. The jobs is not done and if it aborts then it will not run the after routine.

Kim.

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

ray.wurlod · Post by **ray.wurlod** » Tue Jul 29, 2003 5:59 pm

If you check execution status of a job from that job's after-job subroutine, the answer will always be "running".

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

roy · Post by **roy** » Wed Jul 30, 2003 6:18 am

Hi,
you can get the job's status after it finishes in 2 ways:
1. if you run it in a sequencer job, you can branch the logic depending on job's status after it is done by simply connecting links to other stages and specifying the trigger action for each link.

2. write a batch job attach a handle to the desired job and use DSGetJobInfo function (search in designer's help) to get the status of that job.

Hope this helps,

Roy R.

kduke · Post by **kduke** » Wed Jul 30, 2003 8:52 am

Massimiliano

Roy is correct. You cannot check the status of a job in the job or in an after routine. You have to do it outside of that job in either a sequence or a batch job like Roy said. You can do what you want easily if you follow his advice. Tools like DataStage force you to do more steps than sometimes you may want. You can fight the tool or do it the recommended way and save yourself to trouble.

Kim.

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