Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Unanswered: SQL Server Agent 2000 Job never stops

    Hello,

    I've got a couple of jobs who have a odbc connection to a AS400 machine. But when these jobs run they won't stop anymore. I've got to stop these jobs manually so that the next day the jobs can start again as scheduled. The jobs did run all the packages succesfully. Does somebody know how this is possible? It did work fine but since a couple of weeks they just won't stop anymore. I hope you can help me!

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    have a look at the step they were on when they hung. is there a loop in there that has a possibility of becoming endless?

  3. #3
    Join Date
    Jan 2007
    Posts
    2
    I already checked that but there is nothing what would lead to a endless loop. I have exactly the same jobs only with an another connection which work perferctly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •