Home Forums SQL Server 2008 SQL Server 2008 - General Query for find bdetails for Job Name - Enabled - Schedule of job RE: Query for find bdetails for Job Name - Enabled - Schedule of job
Orlando Colamatteo
SSC Guru
Points: 182276
More actions
February 9, 2013 at 2:12 pm
#1586252
Look in msdb for tables dbo.sysjobs, dbo.sysjobschedules and dbo.sysschedules. Those three have what you need.
There are no special teachers of virtue, because virtue is taught by the whole community.--Plato