none
need details

    Question

  • Hi Everyone,

    I need details regarding which user disabled a particular job on my server 2005.Is there any script for the same??.An early response is much appreciated.

    Regards

    Rahul

    Tuesday, November 19, 2013 7:41 AM

Answers

  • Hi Everyone,

    I need details regarding which user disabled a particular job on my server 2005.Is there any script for the same??.An early response is much appreciated.

    Regards

    Rahul


    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/425f2ec2-5faa-4a65-8c6d-9dda3bd6cc77/who-disabled-sql-job?forum=sqldatabaseengine

    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, November 19, 2013 9:19 AM
  • As Ram suggested, I do not think there is a way by default we can track these changes. SQL Server is not storing these information.

    May be one way is to get the login/user who has access to change/view the Agent job and ask them strictly .. ;)


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, November 19, 2013 9:31 AM

All replies