Who updated Job

rjackmanwyn used Ask the Experts™
Is there a log file that shows who and when a job was changed in the SQL server agent jobs?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
You can find when the job was modified by

select date_modified, *
from msdb.dbo.sysjobs

But you wont be able to find out who changed it..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial