Post reply

SQL 2005 Job hangs but executes in query analyzer just fine

  • September 27, 2007 at 8:50 am

    #374831

    I have a job setup that calls a stored procedure. The job hangs on either a insert or update.

    If I execute the stored procedure in Query Analyzer, it processes just fine.

    I tried moving the job to Active Batch, but that didn't help either.

    The stored procedure is gathering data from tables in SQL 2000 and inserting/updating tables in 2005 using linked servers.

    Does any one know of issues, with 2005 and jobs hanging.

  • September 27, 2007 at 11:09 am

    #736865

    I have had two "hanging" problems with jobs and they both turned out to be somewhat based on security. One was a bad proxy account and the other was simply a bad job owner.

    Check the job owner and the permissions the job agent service account have.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply