How Do I Retrieve job Information that how many times it occurs in a week?

[dinesh1440]

Hi,
I want to retrieve how many times a job runs each week.
I checked in sysschedules and syjobschedules tables under msdb database.
But I could not find a way to retreive information.

(Example: weekly jobs can run 5 days a week. I want to find in what are all the days this job runs and how many times. (i.e) If two times a day 10 times a week for this case)

I could manually do for each job seeing the properties of each. But there are more than 150 jobs And am given limited access time to the DB.

Pls do help me on this!!
Thanks in Advance!!

[shweta123]

Hi,

Please refer this Link


Thanks,
Shweta