本文介绍了sql作业列表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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
推荐答案
喜欢
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作业列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!