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 wit
h
> the SQL Server Agent.
> Is it possible to flag an alert to notify when the SQL Server Agent produc
es
> 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 th
e
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 t
o
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 currentl
y
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:
>
> You don't give your SQL Server version number or whether SQL Agent is stil
l
> running and it is just mail that is not getting though? What message is pu
t
> 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 ma
il.
> John