Page 1 of 1

Job Sequence 's log

Posted: Sun Feb 27, 2005 8:25 pm
by benny.lbs
I have written a routine to get the latest DS job log using DSJ.JOBSTARTTIMESTAMP and DSJ.JOBLASTTIMESTAMP to decide the time range, and then use DSGetLogSummary to retrieve the detail job log.

Now I can get the latest DS job log by running this routine in after job routine.

What I want to do is to retrieve sequence's log. But after job routine doesn't exist in sequence, so it can not get the DSJ.JOBSTARTTIMESTAMP and DSJ.JOBLASTTIMESTAMP information.

Would you please give me a hand, thanks a lot.

Posted: Mon Feb 28, 2005 1:42 am
by ray.wurlod
You can add a Routine Activity and modify your routine slightly (copy it to a transform function) so it's callable by that means. Make the Routine Activity the last activity in the Sequence.

Posted: Tue Mar 01, 2005 2:05 am
by benny.lbs
ray.wurlod, I have already tried your suggestion before. But if I add a Routine Activity in the sequence, that means when this activity running the sequence is running too, so how to get its DSJ.JOBLASTTIMESTAMP ?

ray.wurlod wrote:You can add a Routine Activity and modify your routine slightly (copy it to a transform function) so it's callable by that means. Make the Routine Activity the last activity in the Sequence.

Posted: Tue Mar 01, 2005 2:43 pm
by ray.wurlod
You're right, you can't. But, if you're in the routine activity that is the final piece of the sequence, the time "now" should be close enough.

Code: Select all

Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(), "MTS:")

Posted: Thu Mar 03, 2005 7:23 pm
by benny.lbs
That 's a good idea, thanks a lot
ray.wurlod wrote:You're right, you can't. But, if you're in the routine activity that is the final piece of the sequence, the time "now" should be close enough.

Code: Select all

Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(), "MTS:")