Schedule email jobs failing

[tpluskota]

scheduled e-mail jobs seem to be failing on my SQL Server when run by SQLAgent not sure why as the jobs themselves run fine from a query analyzer window, they fail with the following error:

Executed as user: Domain\SQLSERVICE. SqlDumpExceptionHandler: Process 78 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. [SQLSTATE HY000] (Error 0). The step failed.

I have done a bit of research but no clear cut answer one site suggested database corruption and run dbcc functions to check and clean databases. I have re run the job's manually and they work. If anyone has any ideas greatly accepted.

 

[mrdenny]

Sounds like the Account that the Server agent is running the jobs under doesn't have the needed access to something. Are you doing something odd like accessing the OS via xp_CMDShell, or other ESPs?

Denny

--Anything is possible. All it takes is a little research. (Me)