DSGetJobInfo for get sequence name

subrat · Post by **subrat** » Tue Jun 24, 2008 11:27 pm

Hi,

I have a list of 1000 DS jobs. I need to know the sequence name for each of these datastage job which callling it.

e.g: Suppose datastage job is "Job_ABCDE", then i want the sequence which calling it.

Sequence_ABCDE--------->Job_ABCDE.

It seems we can do it by write a routine calling the DSGetJobInfo macro.

Hope i am clear on this.

chulett · Post by **chulett** » Tue Jun 24, 2008 11:34 pm

If you are looking for a macro, a job can find out what is 'calling' it using the DSJobController macro. Same as via the DSGetJobInfo() function using the DSJ.JOBCONTROLLER Info Type.

subrat · Post by **subrat** » Wed Jun 25, 2008 12:22 am

Can you please give me an example how to do it?

Thnaks
Subrat

chulett wrote:If you are looking for a macro, a job can find out what is 'calling' it using the DSJobController macro. Same as via the DSGetJobInfo() function using the DSJ.JOBCONTROLLER Info Type. ...

ArndW · Post by **ArndW** » Wed Jun 25, 2008 2:58 am

The DSJobController macro that Craig mentioned will give you the runtiem information for a job - meaning that it will return the job or sequence name that called it for a given run.
I've been using V8, which has extended metadata reporting capabilities, so cannot give you the exact method to use a V7, but someone will certainly jump in later and post information.

chulett · Post by **chulett** » Wed Jun 25, 2008 6:44 am

Check the online documentation for 'Macros'. At a high level, just... use it. We'd need more specifics about what exactly you are trying to do to give more specific advice.