Retrieving end time of last run
Posted: Thu Sep 26, 2002 1:18 pm
I'm busy writing a reporting program on the jobs that ran last night in DataStage. For this I'm writing a BASIC job that will output the data of all of the jobs in a project: number of links written over all links, start time, job status, ... This will then later on be processed externally to report on "error" conditions.
If I do it this way there does not seem to be an easy way to get the end time of the last run of a job (except for reading the log files). Does anyone know an easy solution to get the end time of the last run of a job.
Changing the jobs themselves to write statistics (inside the job you can get the end time easily) is not an option since I have a couple of hundred jobs in production.
Regards,
Ogmios
If I do it this way there does not seem to be an easy way to get the end time of the last run of a job (except for reading the log files). Does anyone know an easy solution to get the end time of the last run of a job.
Changing the jobs themselves to write statistics (inside the job you can get the end time easily) is not an option since I have a couple of hundred jobs in production.
Regards,
Ogmios