A SQL SERVER script that returns STATS on my SQL JOB

1

I would like to get some stats on some SQL jobs, how long it takes to run, how much memory its using during execution

2

if you look in msdb.dbo.sysjobshistory, you'll get most of what you want, except for memory use. For that, you will probably need to use perfmon and/or extended events

3

I did run a query using sysjobhistory , and joined it to sysjobs which i was able to get run duration.

anyways thx

4

I can't say something about this yet. Need more info on this matter. Hmm..