SQL Mail problem on SQL 2000

[ChuckG]

I've been asked to take a look at why a SQL Agent job that's supposed to run each evening and then send an email out after completion, isn't sending the email.

Looking at the Job History logs, apparently it quit about 3 weeks ago, the log entries say

The job succeeded. The Job was invoked by Schedule 7 (Nightly Sales Files Load). The last step to run was step 1 (Nightly Sales Files Load). NOTE: Failed to notify 'sql_group' via email.

I took a look at the operators and if I try and send a test email to one of the operators I get the following error.

Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog.

I've verified that outlook 2000 is on the SQL server, and I can send/receive mail with it.
The authorized account for the email account is the same as what the SQL Server is using to login with, and that SQLServerAgent service is using.

I'm at a loss as to why SQL Mail isn't working suddenly.

ChuckG

 

[mutley1]

I have had this before - it might be the same resolution but unsure as to the cause (unless of course anyone has been messing on your server).


Open up EM and expand down to SQL Server agent, right click and properties. Check the exchange profile being used is OK (I assume it is), then click test. For some reason we had a server that kept having your issue and that resolved it - kind of a kick start. Probably something more in depth, but thought i would mention it as a first thing for you to try.

If it fails, post the error from that (if it isn't the same)

Cheets,

M.

 

[ChuckG]

mutley1,

Thanks that helped out. I went in and looked and the
mail profile was missing. Did the drop down and re-selected it and restarted the SQL Agent. We're back in business.

Can't imagine anyone changed it, since it's in a secured room. Would be nice to find out why that changes though.

Anyway, thanks for the assistance.

ChuckG

 

[mutley1]

No worries,

Glad to help