Getting dependent jobs and files

bharathappriyan · Post by **bharathappriyan** » Tue Jul 08, 2014 8:37 am

Hi,

I have 5 Master sequences. Each sequence has more than 10 sequence jobs inside them which are calling the individual jobs. All the 5 master sequences are scheduled to run in sequence which is taking more time. I am planning to run some the master sequences in parallel to reduce the run time. Hence i want to find out the dependancy between the master sequences like output files/tables of master sequence 1 are used in master sequence 2/3/4/5 or not.

Is there a way to find out?

Thanks,
Bharathappriyan

chulett · Post by **chulett** » Tue Jul 08, 2014 9:28 am

Not sure why you were quoting yourself but I 'fixed' both of your posts.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 08, 2014 11:31 pm

The easiest way is to ask whomever designed the hierarchy of sequences for a copy of their documentation.

Otherwise you can traverse the design information (to get the dependencies at design time) or the job logs (to get the dependencies for a particular run).

kduke · Post by **kduke** » Thu Jul 10, 2014 10:05 am

The sequence name is in the XML from dsjob -report XML. You can load all the XML into tables and get sequence name and dependent jobs that way.