How to get list of jobs used in a sequence?

MVL · Post by **MVL** » Fri Jun 20, 2008 3:23 am

From command prompt can we find out names of all the jobs used in a sequence? Is there any table which can be used?

I was thinking of reading the log file of sequence, but is there any better option?

Thanks

DS_SUPPORT · Post by **DS_SUPPORT** » Fri Jun 20, 2008 4:51 am

This can be done by doing a select in DS_JOBOBJECTS, Kim Duke has posted the code already. Do a Search, alternatively you can open the jobcontrol of the Sequence, and look at the first part. If you have followed some naming conventions for your jobs, it would be easy to extract from there.

DSguru2B · Post by **DSguru2B** » Fri Jun 20, 2008 11:56 am

look into the dssearch command. It should be in the manual under Command line Interface. Or search for it here.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 20, 2008 3:15 pm

The only way to get a list of the jobs USED in a job sequence is to read the log. The easiest way is to check the event called "summary of sequence run".

This is because the logic of a job sequence (triggers, nested condition activities) may cause some of the jobs in the job sequence design not to be executed under some circumstances.