May 23, 2011 at 3:33 pm
Hi,
Can any one let me know where exactly can we capture the changes to the job that has been created an running successfully and what would be the system tables where exaclty I could look for this kind of changes that have happened to the SQL Server Jobs.
Regards,
Ravi
May 23, 2011 at 10:24 pm
RaviShankar1234 (5/23/2011)
... changes that have happenes to the SQL Server Jobs.
I don't think SQL Server stored all the changes that you make to a job. I think it stores only changed job.
Anway, job details are stored in msdb.dbo.sysjobs and msdb.dbo.sysjobsteps tables.
You can check the backup of msdb database for older version of the job.
May 24, 2011 at 8:55 am
I would agree with Suresh. I have never seen a place where you can track the changes made to a job over time.
However, you could set up logging that tracks these changes in the future. If you need this information going forward, that is.
May 26, 2011 at 6:09 pm
You could also give SQL Agent Insight a try. This product can notify you when a job has been modified or created via email, however, in this release it won't yet show you what has changed at the step level. That is slated for a future release. It can be found here www.brentec.ca.
Meanwhile, there are scripts, including powershell ones that will document all jobs with steps, give a search, even on this site.
Regards.
May 27, 2011 at 5:01 am
use Database audit specification against msdb database because all jobs information insert or update in this database
http://msdn.microsoft.com/en-us/library/cc280386.aspx
http://technet.microsoft.com/en-us/library/cc280404.aspx
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 27, 2011 at 8:38 am
I've used a trigger on sysjobs to alert me when jobs are enabled/disabled. That worked fine. You could do something similar for sysjobsteps.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply