January 30, 2009 at 3:11 am
Need some advise!
I have several databases in my SQL 2005 environment which all have several jobs associated with them.
I would like one central DB which holds all Success and Failure information in one tables.
i.e. For each success or failure job completion it will write a row in the table with information like:
Database Name, Job Name, time started, success, fail, error message
Can this be done?
January 30, 2009 at 3:28 am
A Little Help Please (1/30/2009)
Need some advise!I have several databases in my SQL 2005 environment which all have several jobs associated with them.
I would like one central DB which holds all Success and Failure information in one tables.
i.e. For each success or failure job completion it will write a row in the table with information like:
Database Name, Job Name, time started, success, fail, error message
Can this be done?
You already have such a database, it's called msdb. Look into the sysjobhistory table and you find a row for each jobstep.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply