--这样或许也能看到点信息 select * from msdb.dbo.sysjobhistory a inner join msdb.dbo.sysjobs b on a.job_id=b.job_id where b.name='作业名'
我汗一个,我的意思是通过SQL,通过属性谁都知道啊
select a.name as JOB_NAME, b.next_run_date as RUN_DATE, b.next_run_time as RUN_TIME from msdb.dbo.sysjobs a left outer join msdb.dbo.sysjobschedules b on a.job_id = b.job_id
select *
from msdb.dbo.sysjobhistory a
inner join msdb.dbo.sysjobs b on a.job_id=b.job_id
where b.name='作业名'
select a.name as JOB_NAME,
b.next_run_date as RUN_DATE,
b.next_run_time as RUN_TIME
from msdb.dbo.sysjobs a
left outer join msdb.dbo.sysjobschedules b
on a.job_id = b.job_id