job's previous run time

[harryhome]

Hi

I m designing a job where i wann fetch the source data if its got updated after last run of the same job.

hence i m looking for the last run's timestamp, so can i get last's runtime of same job in current run?

plz guide

[ArndW]

You should do this checking in a sequence. You can write your own routine using the following logic:

- call DSAttachJob() to attach to the job
- call the routine DSGetJobInfo() with DSJ.JOBLASTTIMESTAMP
- call DSExecute() to return the file date/timestamp
- compare

[kumar_s]

If you are calling it from dsjob function, you can as well use

Code: Select all

dsjob -jobinfo $Project $Job | grep 'Last Run Time'

[DSguru2B]

If you want the timestamp in YYYY-MM-DD hh:nn:ss format then run the following

Code: Select all

dsjob -report <<PROJECTNAME>> <<JobName>> | grep -w "Job end time" | awk -F"\=" '{print $2}'

[ray.wurlod]

Because you're doing this in a job sequence before the job starts, you can simply request the job start timestamp in a Routine activity.

Code: Select all

FUNCTION GetJobStart(TheJobName)
$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF
hJob = DSAttachJob(TheJobName, DSJ.ERRNONE)
Ans = DSGetJobInfo(hJob, DSJ.JOBSTARTTIMESTAMP)
If Ans = DSJE.BADHANDLE Then Ans = @NULL
ErrCode = DSDetachJob(hJob)
RETURN(Ans)