Job Sequence 's log

benny.lbs · Post by **benny.lbs** » Sun Feb 27, 2005 8:25 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 28, 2005 1:42 am

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.

benny.lbs · Post by **benny.lbs** » Tue Mar 01, 2005 2:05 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 01, 2005 2:43 pm

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:")

benny.lbs · Post by **benny.lbs** » Thu Mar 03, 2005 7:23 pm

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:")