select top 1 * from sysjobs where name like 'Full Backup.Daily'
select top 10 * from msdb.dbo.sysjobhistory sj where Job_id = 'CFFDFADD-60C8-4E8E-B00C-BFC74822926C'
order by run_date desc,run_time desc
OR
select top 10 * from msdb.dbo.sysjobhistory sj where Job_id =
(select top 1 Job_id from sysjobs where name like 'Full Backup.Daily')
order by run_date desc,run_time desc
No comments:
Post a Comment