Results 1 to 5 of 5

Thread: Scheduled job hanging

  1. #1
    Join Date
    Jun 2005
    Posts
    1

    Scheduled job hanging

    Hi

    I have an sql server 2000 scheduled job that runs ok for a period and then hangs. The job basically copies data from a complex view to a table once every second hour.

    If I stop the agent service and restart it then start the job manually all goes OK, but next time the job runs it will hang (always on the same part of the job).

    The job neither consumes memory or sets off hdd activity and the database size is no more than 300 Mb.....I'm baffled.

    Does anyone have any similar experience or a solution?

    //Paul

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    what SQL server service pack you have on that machine?

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    When the job is hanging, is the process blocked?.
    Can you do dirty read on the target table to see if it's adding any rows?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Or run sp_who2 to see if have any blocking issue.

  5. #5
    Join Date
    Feb 2003
    Posts
    1,048
    Are you running DTC and using Windows NT fibers? Are you doing a distributed transaction?

Posting Permissions

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