Capture SQL Transaction errors

Dear All

In Sql Server there is a concept of job Scheduling and if we want to track those jobs errors then we can do following things
1) Download ZIp
2) Extract the zip
3) create a stored procedure in MSDB database from the extracted text file.
4) schedule the job of trans_error.vbs in task schedular for every day evening at 6.00 PM

It will collect the erorrs occured while executing the SQL scheduled jobs for the entire day and send email by makes it zip to the email ids which are in Trans_error.vbs ( please do change the email ids )


Prashant Deshpande


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s