DSXchange

Hi,

Is it possible to find how many jobs have run on a particular day.

Thanks,
Kayalbas

Sure. Biggest hurdle will be if you mean their most recent run or an older run. The former is a simple 'dsjob' query, the latter will need intact logs and more involved scripting.

Or, if your jobs are scheduled on any scheduler like Autosys, Control-M; you can take help of its run status...

Thanks for the information.

Could you kindly let me know what dsjob query needs to be used to get the recent job run.


Thanks,
Kayalbas

EtlStats can get the last run of all jobs. There is a second job which can get all the job runs still in the logs.

dsjob -lognewest would give you the latest log details, from which you can find the date of the last run.
-logsum, -logdetail can also be used for the same purpose.

Or even easier might be to (off the top of my head) use "dsjob -jobinfo" which would include that information in a format that might be a little easier to parse out.

Open Director to Status view. In View menu disable display of categories. Click on run date column to sort by this column. Voila!