Page 1 of 1
Job Start TIme and Job End Time
Posted: Wed Jan 17, 2007 11:59 pm
by pradkumar
Hi
I am runing a master sequence. I would like to capture the start time of the job and End time of the job in a file or table.
How to accomplish this?
Posted: Thu Jan 18, 2007 12:54 am
by rleishman
A long time ago, I tried running the BuiltIn DSJobReport subroutine as the last activity of a Job Sequence, instead of from the After-Job subroutine of a server job, as is intended.
From memory, it mostly worked, except the status showed as RUNNING, insteead of FINISHED. I chucked in the idea around then. I can't remember whether it showed an accurate Job End Time though. Give it a go.
Posted: Thu Jan 18, 2007 5:04 am
by kumar_s
Find the list of jobs in Jobsequence, and use
Code: Select all
dsjob -report <project> <jobname> BASIC
. Or simple use the Popular EtlStatus from KimDuke homepage.
Posted: Thu Jan 18, 2007 3:45 pm
by ray.wurlod
If you use DSGetJobInfo() from an after-job subroutine you can request the "interim status" - that is, the status with which the job will finish assuming it's not aborted by the after-job subroutine's ErrorCode argument.