log information

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
svipul16
Participant
Posts: 8
Joined: Sun Sep 23, 2007 10:29 am

log information

Post by svipul16 »

Hi,

Is there any method for getting job names and there ids which are in the sequencer.i.e when i run sequencer i want to collect the log information of sequencer which has sequencer id,job ids,jobname,seq starttime,end time.

Thank u

vipul
anandkumarm
Premium Member
Premium Member
Posts: 55
Joined: Tue Feb 24, 2004 8:17 am

Re: log information

Post by anandkumarm »

HI
Try using dsjob -logsum <project_name> <jobname>
if that is what you are asking for
Thanks
svipul16 wrote:Hi,

Is there any method for getting job names and there ids which are in the sequencer.i.e when i run sequencer i want to collect the log information of sequencer which has sequencer id,job ids,jobname,seq starttime,end time.

Thank u

vipul
svipul16
Participant
Posts: 8
Joined: Sun Sep 23, 2007 10:29 am

Re: log information

Post by svipul16 »

No, if i run sequencer i want the jobnames and there ids which are running in sequence.
thanks for ur reply

[quote="anandkumarm"]HI
Try using dsjob -logsum <project_name> <jobname>
if that is what you are asking for
Thanks
svipul16
Participant
Posts: 8
Joined: Sun Sep 23, 2007 10:29 am

Re: log information

Post by svipul16 »

No, if i run sequencer i want the jobnames and there ids which are running in sequence.
thanks for ur reply

[quote="anandkumarm"]HI
Try using dsjob -logsum <project_name> <jobname>
if that is what you are asking for
Thanks
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I don't know about V8, but at 7 there is no automated way of doing that directly that I can think of. But you can get at this information using the builtin routines; one of the returned values of DSGetJobInfo() is the parent job - which would be the calling job sequence. So if you looped through all jobs and got the runtime log information you wanted for each job whose parent is the job sequence you would have your result.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

I have a job included with EtlStats which will check to see if any job failed in a sequence called EtlChkSeqJobsNotRun. It is all job control so you have source code. It will email the log file as an html attachment any group of people you want if a job fails.

So the logic to figure out which job is in a sequence is in this job.
Mamu Kim
Post Reply