sql作业列表 [英] List of sql jobs

问题描述

Hi Team，

他们可以选择以下列列表获取所有职位信息 

Is their any option to get all the jobs information with bellow columns 

职位名称

已启用

日程表的名称

计划执行的频率

收件人

Job Name
Enabled
Name of the schedule
Frequency of the schedule execution
recipients

收件人是指和cc邮件ID

recipients means to and cc mail id's

谢谢Bala Narasimha

Thanks Bala Narasimha

推荐答案

可能使用msdb表

Possible using msdb tables

喜欢

select j.name,case when j.enabled = 0 then 'Disabled' else 'Enabled' end as EnabledStatus,s.name,
CASE s.freq_type
WHEN 1 THEN 'One time'
WHEN 4 THEN 'Daily'
WHEN 8 THEN 'Weekly'
WHEN 16 THEN 'Monthly'
WHEN 32 THEN 'Monthly, relative to freq_interval'
WHEN 64  THEN 'Runs when SQL Server Agent service starts'
WHEN  128 THEN 'Runs when the computer is idle'
END AS Frequency
from sysjobs j
join sysjobschedules js
on js.job_id = j.job_id
join sysschedules s
on s.schedule_id = js.schedule_id

关于收件人，你的意思是获得工作通知的人员名单或工作步骤提交报告的人员名单等？

Regarding recipients, do you mean list of people getting job notifications or list of people to whom job step delivers report etc?

这篇关于sql作业列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！