PRINT '===================================='
PRINT 'New created Maintanance plan in week'
PRINT '===================================='
select CONVERT(VARCHAR(25), plan_name) plan_name,date_created
from msdb..sysdbmaintplans
where convert(varchar(8),date_created,112)> convert(varchar(8),getdate()- 7,112)
PRINT '=========================='
PRINT ' New created Job in week '
PRINT '=========================='
select * from msdb..sysjobs where date_created > convert(varchar,getdate()-7,101)
No comments:
Post a Comment