Getting a list of job name and start time
Posted: Mon Jun 17, 2013 8:59 pm
I am working on to get a list of DataStage Job/Sequence name whose start time is >= April 2013. Repository has jobs/sequence which are running daily and some which are decommissioned(Not running, but exist). I am in process of identifying which have run for past 2 months.
What we did-
1. Using "dsjob -ljobs" command get list of jobs
2. Loop through all listed jobs again to get multiple instance job names with instances using -linvocations
3. Loop through each job to get information on start time etc using "dsjob -jobinfo"
4. Write script to filter only Job name, start time
Is there a better way of getting this information using LOGGING_CATEGORY1466CB5F or DS_JOBS of UV. Please advice
What we did-
1. Using "dsjob -ljobs" command get list of jobs
2. Loop through all listed jobs again to get multiple instance job names with instances using -linvocations
3. Loop through each job to get information on start time etc using "dsjob -jobinfo"
4. Write script to filter only Job name, start time
Is there a better way of getting this information using LOGGING_CATEGORY1466CB5F or DS_JOBS of UV. Please advice