Getting start/end times of all CHILD jobs/sequencers

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
laiko
Premium Member
Premium Member
Posts: 35
Joined: Sun May 25, 2008 10:55 am

Getting start/end times of all CHILD jobs/sequencers

Post by laiko »

Hi,

I have a requirement wherein given the Main sequencer name, I have to save to database the start and end time of all its child jobs and child sequencers. I dont know how to write a routine as I am a beginner, needless to say, the function which returns the child jobs/sequencers of a main sequencer. Please help.

Thanks in advance.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can open the log of the main job sequence, and obtain the start times and end times from there. Director includes a Print option under the Project menu and this, in turn, includes a print to file choice. You could then create a simple job to read that file and write the desired information to your database.

Otherwise you need to learn how to write routines or hire someone who can.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply