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