Custom Query to check Frequency, Interval and Time of multiple Job’s in SQL Server
'In my [previous post] I discussed about the system SPs that we can use to get details of a SQL Job, like its Name, ID, Description, Schedule, etc. But what if you need to check these details of various SQL Jobs?
Here in this post we will see how we check the Job Schedule of various SQL Jobs, like:
1. Enable/Disable
2. Frequency (Once, Daily, Weekly, Monthly, etc.)
3. Interval (Specific time, Seconds, Minutes, Hours, etc.)
4. Start Date and Time
5. Description
… by using some system views, like:
– sysJobs
– sysJobsShedules
– sysSchedules'...
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt