August 22, 2013 at 2:12 pm
Hello all,
I have seen this error pop up quite a bit in the SQL Server Agent log. I have looked for answers online and everyone is saying to just restart the SQL Server Agent. Well, I am not doing that, but it is somehow coming and going. I compared this log with the Database Mail Log and I see a bunch of 'DatabaseMail process is started' and 'DatabaseMail process is shutting down'. From what I know, the process will shut itself down after 10 minutes of inactivity, but then start itself up again when a job calls for it.
The [264] error is happening at times between when the DatabaseMail process shuts down and when it starts up. So it would seem that a job or something is trying to send an email when the process is shut down, but the process is not starting up. Again, I read that to fix that just restart the agent, but I am not doing that and the process starts up again. Is the agent somehow restarting itself?
Other than understanding what is happening, what I would really like to be able to do is identify the job or process that is trying to send an email but failing. Does anyone know how I can do that?
Thanks!
April 22, 2015 at 10:25 am
Incorrect post.
Deleted.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply