--to identify the sql jobs in a server, this is run under msdb
select * from dbo.sysjobs
--to identify the sql jobs schedules in a server, this is run under msdb
select * from dbo.sysjobschedules
--to identify the sql jobs history in a server, this is run under msdb
select * from dbo.sysjobhistory
--this gives the complete schedules listed under the sql agent jobs
select * from dbo.sysschedules
No comments:
Post a Comment