Find/List number of Jobs ran on a Particular Day

Kayalbaskaran · Post by **Kayalbaskaran** » Tue May 04, 2010 4:46 am

Hi,

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

Thanks,
Kayalbas

chulett · Post by **chulett** » Tue May 04, 2010 5:31 am

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.

dspxlearn · Post by **dspxlearn** » Tue May 04, 2010 6:11 am

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

Kayalbaskaran · Post by **Kayalbaskaran** » Tue May 04, 2010 6:43 am

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

kduke · Post by **kduke** » Tue May 04, 2010 7:45 am

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.

kumar_s · Post by **kumar_s** » Tue May 04, 2010 8:05 am

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.

chulett · Post by **chulett** » Tue May 04, 2010 8:07 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue May 04, 2010 4:54 pm

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