question

cstephen avatar image
cstephen asked

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
sql-agentsql server 2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.