DSXchange

Hi,

I can easily extract the latest run log of a multi instance job for a given invocation using dsjob CLI command but it takes forever when there is too much log and instances.

dsjob -logdetail <Project> <Job>.<InvocationID>

I tried below command but it returns two log runs info including latest and have same WAVE.NO, but I need only latest run log info. So, what field holds latest run tag for a given invocation in RT_LOG?

$DSHOME/bin/dssh "SELECT @ID FMT '20L',TIMESTAMP FMT '20L',EVAL \"IF @RECORD<7> MATCHES '' THEN 'NULL' ELSE @RECORD<7>\" FMT '100L' AS INVOCATION, FULL.TEXT FMT '260L', WAVE.NO FMT '20L' FROM RT_LOG87 WHERE CAST(@ID AS VARCHAR) NOT LIKE '/%' and INVOCATION=<INV ID> and WAVE.NO=(SELECT MAX(WAVE.NO) FROM RT_LOG87 WHERE INVOCATION=<INV ID>) ORDER BY @ID SUPPRESS COLUMN HEADING COUNT.SUP COL.SPCS;"

Thanks in advance!

I think everyone is on vacation but appreciate if anyone has any clue of my requirement below.

You need to get the last ID using dsjob -loginfo. This needs to be added to your SELECT WHERE clause.

Thank you Duke!

I think you mean dsjob -lognewest or dsjob -logsum but this should be run before we start the job and should be used after job is completed in the where clause to get the latest log details.

This would be a two step process. Don't we have any flag within the RT_LOG which keeps track of latest run for a given invocation?

There is no flag. You could, of course, determine the most recent "job started" event by constraining on max of TIMESTAMP and event type.