Logging

I'm trying to log who changes job owners in SQL Server Agent. I have looked at SQL Server Agent logs and SQL Server logs and did not see anything that highlights that.

Where can I find that information? If not currently available, how do I set up to view those logs?

September 10th, 2015 4:45pm

Ami,

A job can be edited only by its owner or members of the sysadmin role.

Please try below script to find the details;

exec msdb.dbo.sp_help_job @job_name = 'somejob';

Free Windows Admin Tool Kit Click here and download it now
September 10th, 2015 5:29pm

You can get this information by enableing server level auditing.

YOu will get lots of information about your server and user actions.

Having said that enabling the server level auditing coule degrade your SQL sever performance.

September 10th, 2015 8:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics