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 )

Thanks

Prashant Deshpande

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s