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!
Latest logdetails using RT_LOG file
Moderators: chulett, rschirm, roy
Re: Latest logdetails using RT_LOG file
I think everyone is on vacation but appreciate if anyone has any clue of my requirement below.
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?
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: