SQLAgent crash

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Maurizio Camurati
    #1

    SQLAgent crash

    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


    Tags: None
    • Andrea Montanari
      #2
      Re: SQLAgent crash


      "Maurizio Camurati" <mcamurati@tso. it> ha scritto nel messaggio
      news:ylmCc.5223 1$G%.27971@torn ado.fastwebnet. it...[color=blue]
      > 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[/color]
      the[color=blue]
      > 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.[/color]

      you are probably running an Italian localized version of SQL Server 2000,
      any edition...
      this is a known problem that has been signaled on july 2003 to Microsoft
      representatives and will probably be fixed in next service pack..
      at http://tinyurl.com/2md7b you'll see the only known workaround to this
      bug, as long as some comments about it.
      --
      Andrea Montanari (Microsoft MVP - SQL Server)
      http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
      DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
      (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
      interface)
      --------- remove DMO to reply

        Comment

        • Maurizio Camurati
          #3
          Re: SQLAgent crash

          My SQL Server is an Italian version and I solve the problem changing the
          ..rll file as you have suggested!

          Many thanks!!!


          "Andrea Montanari" <andrea.sqlDMO@ virgilio.it> wrote in message
          news:2juqdjF15u obqU1@uni-berlin.de...[color=blue]
          >
          > "Maurizio Camurati" <mcamurati@tso. it> ha scritto nel messaggio
          > news:ylmCc.5223 1$G%.27971@torn ado.fastwebnet. it...[color=green]
          >> 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[/color]
          > the[color=green]
          >> 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.[/color]
          >
          > you are probably running an Italian localized version of SQL Server 2000,
          > any edition...
          > this is a known problem that has been signaled on july 2003 to Microsoft
          > representatives and will probably be fixed in next service pack..
          > at http://tinyurl.com/2md7b you'll see the only known workaround to this
          > bug, as long as some comments about it.
          > --
          > Andrea Montanari (Microsoft MVP - SQL Server)
          > http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
          > DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
          > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
          > interface)
          > --------- remove DMO to reply
          >[/color]


            Comment

            Previous template Next
            Working...