Page 1 of 1
All the Job Activity details in a Sequence
Posted: Tue Nov 17, 2009 6:28 am
by varaprasad
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.
Posted: Tue Nov 17, 2009 6:32 am
by chulett
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.
Posted: Tue Nov 17, 2009 4:26 pm
by ray.wurlod
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)?
Posted: Tue Nov 17, 2009 11:22 pm
by varaprasad
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.
Posted: Wed Nov 18, 2009 1:41 am
by dsx999
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 ?
Posted: Wed Nov 18, 2009 2:54 am
by ray.wurlod
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.
Posted: Wed Nov 18, 2009 7:20 am
by chulett
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.
Posted: Wed Nov 18, 2009 8:34 am
by varaprasad
Thanks Ray and Craig.