How to find who has modified maintenace plan backupjobs?
Hi folks, Recently we had a trouble, in Maintenace plan for backup jobs we configured as retention period of older than 4 weeks jobs has to be deleted automatically. but someone has changed the rention period as 3 weeks. we are not able to found out who has modified the plan? Is there any query has available to modified time,login details has modified the plan? I checked this query: select * from sysmaintplan_logdetail select * from sysmaintplan_log select * from msdb..sysmaintplan_plans (nolock) select * from msdb..sysmaintplan_subplans not having those information...kindly clarify my doubts. Regards stephen