February 28, 2011 at 7:31 am
Hi,
I have some Backup Jobs set up in SQL Agent Job through SQL Script and some with Litespeed script . I see some of the back up jobs Fails often and I had to manually check the history of the Job to find the Error Log.
How can I automate to send the error log directly to email (or) DBA group when a Agent Job fails ??
Please suggest
Regards
Kay
February 28, 2011 at 8:47 am
You can create a custom alert for any error #...
View the error in the log, write down the number. Go to Alerts and add it manually. You will find an option to manually enter an error number. Someone else may have another solution, but this is just straight off the top of my head.
February 28, 2011 at 9:11 am
You can also enable Database Mail [/url]and configure the job to send an email when the job fails.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 28, 2011 at 9:34 am
This should give you everything you need.
http://www.mssqltips.com/tip.asp?tip=1523
Please note under the Database Mail heading, there is another link provided in giving you step by step for configuring email for the alerts.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply