Possible to alert on SQL Server Agent Error Log?

We have one SQL server where the mail may disconnect from time to time with
the SQL Server Agent.
Is it possible to flag an alert to notify when the SQL Server Agent produces
an error in the SQL Server Agent Error Log?Hi
"ssciarrino" wrote:
> We have one SQL server where the mail may disconnect from time to time with
> the SQL Server Agent.
> Is it possible to flag an alert to notify when the SQL Server Agent produces
> an error in the SQL Server Agent Error Log?
You don't give your SQL Server version number or whether SQL Agent is still
running and it is just mail that is not getting though? What message is put
in the log?
Have you looked at creating an ALERT for this if you can trap the error
level or number? You would have to use a method other than emails to send the
information! You could look at using MOM to check the log files for this.
A common cause of email stopping is issues connecting to the email server.
If you have network issues you may want to sort them out. SMTP email tends to
be less prone to this to use this with SQL 2000 you can use xp_smtp
http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database mail.
John|||Hi John
Thanks for the insight I will look into this...at the moment we are SQl
2000 but as you mention SQL 2005 doesn't have this problem. We are currently
migrating to SQL 2005, may not have to visit this after upgrade.
I was looking for any type of log message that was error (red) but it
appears I have to narrow down via alert via error number/message
"John Bell" wrote:
> Hi
> "ssciarrino" wrote:
> > We have one SQL server where the mail may disconnect from time to time with
> > the SQL Server Agent.
> >
> > Is it possible to flag an alert to notify when the SQL Server Agent produces
> > an error in the SQL Server Agent Error Log?
> You don't give your SQL Server version number or whether SQL Agent is still
> running and it is just mail that is not getting though? What message is put
> in the log?
> Have you looked at creating an ALERT for this if you can trap the error
> level or number? You would have to use a method other than emails to send the
> information! You could look at using MOM to check the log files for this.
> A common cause of email stopping is issues connecting to the email server.
> If you have network issues you may want to sort them out. SMTP email tends to
> be less prone to this to use this with SQL 2000 you can use xp_smtp
> http://www.sqldev.net/xp/xpsmtp.htm and include extra steps in the jobs to
> send the sucess/failure emails. SQL 2005 has SMTP inbuilt with database mail.
> John