Hi all, I have some trouble with SQLAgent...when I try to schedule a job
that invokes a script (vbs, java, cmdshell,...), SQLAgent crashes at the
moment of scheduled execution. If I try to execute it manually, all works
fine. This installation runs on a cluster Win2003 and the node initiate a
failover if I don't delete the job and then restart Agent (I can't start the
service before deleting that job!!!). Event viewer logs something like:
"LOG] Exception 5 caught at line 191 of file ..\src\refreshr.c.
SQLServerAgent initiating self-termination".
I've already tried to debug the service but my dump did not help me.

Any suggestion?

Thanks
camau

You might want to open a case with PSS over this. Crashes aren't normal
behavior for SQL Agent. You can stop the failover if you open the cluster
administrator tool, right click on the SQL Agent resource, and select
properties. Click the advanced tab and clear the 'affect the group'
checkbox. This will keep an agent crash from initiating a failover. Be
sure and put it back once you have the underlying problem fixed.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Maurizio Camurati" <mcamurati (AT) tso (DOT) it> wrote

Ok, I will try this workaround.
Many thanks!

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote