use msdb
go
select j.name as JOB_Name,*
from dbo.sysschedules S with(nolock)
inner join dbo.sysjobschedules SCH with(nolock) on SCH.schedule_id=S.schedule_id
inner join dbo.sysjobs J with(nolock) on SCH.job_id = J.job_id
inner join dbo.sysjobsteps P with(nolock) on SCH.job_id = P.job_id
where J.enabled=1 and j.name ='JobName'
查询一个JOB是否存在
最新推荐文章于 2020-01-16 14:07:15 发布