-
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
-
what SQL server service pack you have on that machine?
-
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?
-
Or run sp_who2 to see if have any blocking issue.
-
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
-
Forum Rules
|
|