SQLAgent crash

From: Maurizio Camurati (mcamurati_at_tso.it)
Date: 06/23/04

  • Next message: Colin Basterfield: "Insert using Subqueries" 
    Date: Wed, 23 Jun 2004 23:04:19 +0200

    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

  • Next message: Colin Basterfield: "Insert using Subqueries"

    Relevant Pages

    • SQLAgent
      ... I have some trouble with SQLAgent...when I try to schedule a job ... that invokes a script, SQLAgent crashes at the ... moment of scheduled execution. ... SQLServerAgent initiating self-termination". ...
      (microsoft.public.sqlserver.server)
    • SQLAgent
      ... I have some trouble with SQLAgent...when I try to schedule a job ... that invokes a script, SQLAgent crashes at the ... moment of scheduled execution. ... SQLServerAgent initiating self-termination". ...
      (microsoft.public.sqlserver.tools)
    • SQLAgent crash
      ... I have some trouble with SQLAgent...when I try to schedule a job ... that invokes a script, SQLAgent crashes at the ... moment of scheduled execution. ... SQLServerAgent initiating self-termination". ...
      (microsoft.public.sqlserver.clustering)
    Loading