SQL Mail agent failing

[chatridge]

I am running SQL 2000 on Windows 2000 Server. I have an email notification setup to run when my SQL Agent jobs complete. The notifications work for a day or two and they stop. I need to restart the SQLAgent service to get them working again. If I do a test after I realize they are failing 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."

The job history log shows:
"NOTE: Failed to notify (Joe Smith) via email)

The event log is showing:
"he VB Application identified by the event source logged this Application DTSBackup 2000 Command Line Tool: Thread ID: 3008 ,Logged: Error Number: 70
Err Source: DTSBackup2000Cmd
Err Description: Permission denied "

Any ideas what would be causing the SQL Mail service to stop every few days? Is this a bug in SQL Server 8?

 

[JayKusch]

When you say ... "I need to restart the SQLAgent service to get them working again." are you stopping and then restarting the Agent OR are you finding that the agent has stopped and you are starting it again?

Thanks

J. Kusch

 

[chatridge]

The service is running - I just have to restart it. Its almost like just the SQL Mail portion of the service stalls and a restart fixes it.

 

[NickCorlett]

I had a similar problem and found that I had to reboot the server before the SQLAgent would perform the jobs consistently.

Hope this helps.