Date and Time of Last Successful Job Run

snassimr · Post by **snassimr** » Tue Dec 30, 2008 5:06 am

Hi !!!

I need to know when last time the JOB finished with status Ok ( =1)
Can I know it with DS Functions without to scan Log of Job ?

Thank you

ArndW · Post by **ArndW** » Tue Dec 30, 2008 5:45 am

I don't have access to the documentation here to give you the exact options, but the command is DSGetJobInfo()

ray.wurlod · Post by **ray.wurlod** » Tue Dec 30, 2008 7:08 am

The answer is no. This is only possible by scanning the job log. DSGetJobInfo() can return the current (= most recent) job run's information.

chulett · Post by **chulett** » Tue Dec 30, 2008 7:58 am

Right... and this supposes that the 'last successful run' information is still in the log. If you really need this, you'd be better off capturing it elsewhere after every job run.

ArndW · Post by **ArndW** » Tue Dec 30, 2008 8:15 am

Ahh, when I responded I skipped over the "successful" keyword, I thought the poster just wished the last run information. As stated, this information is not directly available and perhaps not even available at all if the log has been cleared or purged.
To date I've implemented systems where the statistics are automatically collected after each job run and added to a statistics hashed file. This can be done by several methods, each of which have their advantages and disadvantages. One method is to add an after-job call to each job, another is to have a background job running constantly and checking every n-minutes for completed run and the last method I've used is to modify the verb in the VOC that calls jobs to automatically trigger the statistics collection.

sachin1 · Post by **sachin1** » Tue Dec 30, 2008 8:17 am

You cannot directly test for "OK", you need to use below function and track the value of Status_value(a user defined variable), if the Status_value = 2 then your job finished "ok"

Status_value = DSGetJobInfo (DSJ.ME, DSJ.JOBINTERIMSTATUS)

also the function DSGetLogSummary can help.

but as replied earlier by ray you need to read a job log where all information is stored.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 30, 2008 8:53 am

That is so wrong. Status 1 means OK, status 2 means that there was at least one warning/alert message logged. But we're straying off topic.

snassimr · Post by **snassimr** » Tue Dec 30, 2008 9:00 am

Thank you all . It seems to collect statistics permanently and not from time to time is the best way.