All the Job Activity details in a Sequence

varaprasad · Post by **varaprasad** » Tue Nov 17, 2009 6:28 am

I have a sequence which contains some Job Activity components along with some other activities.
Now I want to know if there is a way to display the names of the jobs that are part of the sequence. Basically I want to know if there is any command or SQL to get these details.

Similarly is there any way (command or function or SQL) to know about different stages and links that are used in my job ?

Any information is appreciated.

chulett · Post by **chulett** » Tue Nov 17, 2009 6:32 am

For the first question, I'd look into the dssearch command. For the second one, the various DSGet functions like DSGetJobInfo, DSGetStageInfo, etc, or their command line dsjob equivalents.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 17, 2009 4:26 pm

Do you mean the jobs that are designed into the sequence as Job activities, or do you mean the jobs that are actually executed when the sequence runs (which may be only a subset of the first list, depending on the logic of the sequence)?

varaprasad · Post by **varaprasad** » Tue Nov 17, 2009 11:22 pm

ray.wurlod wrote:Do you mean the jobs that are designed into the sequence as Job activities, or do you mean the jobs that are actually executed when the sequence runs (which may be only a subset of the first list, depending on the logic of the sequence)?

The jobs that are actually executed when the sequence runs.

dsx999 · Post by **dsx999** » Wed Nov 18, 2009 1:41 am

chulett wrote:For the first question, I'd look into the dssearch command. For the second one, the various DSGet functions like DSGetJobInfo, DSGetStageInfo, etc, or their command line dsjob equivalent ...

I couldn't find this command in my system. (my DataStage is 7.5 on Windows) I ran a search even. something has to be explicitly installed ?

ray.wurlod · Post by **ray.wurlod** » Wed Nov 18, 2009 2:54 am

Look in the sequence's job log. Near the end is a "summary of sequence run".

You can interrogate this entry with API functions (such as DSGetNewestLogId, DSGetLogEvent) or with dsjob command equivalents.

chulett · Post by **chulett** » Wed Nov 18, 2009 7:20 am

dsx999 wrote:
chulett wrote:For the first question, I'd look into the dssearch command. For the second one, the various DSGet functions like DSGetJobInfo, DSGetStageInfo, etc, or their command line dsjob equivalent ...
I couldn't find this command in my system. (my DataStage is 7.5 on Windows) I ran a search even. something has to be explicitly installed ?

No, it is there under both the main client folder and the DSEngine/bin folder on the server.

varaprasad · Post by **varaprasad** » Wed Nov 18, 2009 8:34 am

Thanks Ray and Craig.