I need to figure out which steps have been modified since the beginning of the month. I can find which jobs have been modified, but some of the jobs have 20+ steps, so knowing which specific step was modified would be very useful.

This is where I found the job/step msdb info: https://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/

  • 1
  • @AaronBertrand If I'm reading that correctly (I'm still a beginner so bear with me) it's a way to monitor the steps going forward. So I would have to set it up and wait for it to fill with data before it is useful? – A. Folken Jul 10 '18 at 15:50
  • 1
    That’s right. SQL Server simply doesn’t track step modifications by default. You can’t go back in time and set up a video camera to catch someone stealing a package off your porch, but you can set it up now and catch the next person. – Aaron Bertrand Jul 11 '18 at 2:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.