SQL Schedules job failed

• dva2007

  SSCertifiable

  Points: 7707

  More actions

  June 4, 2008 at 7:21 am

  #187609

  Hi friends,

  i have one simple job scheduled which sends email with appropriate message.

  It runs every day and sends appropriate mail. There was no problem from 10 days and suddenly it failed today with following error.

  ----------

  Remote tables are not updatable. Updateable keyset-driven cursors on remote tables require a transcation with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor.

  [SQLSTATE 01000] (Message 16953) Mail Sent.

  [SQLSTATE 01000] (Message 17967) sqlDumpExceptionHandler: Process 56 generated fatal exception c0000005

  EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

  [SQLSTATE HY000] (Error 0). The step failed.

  -----------

  Then i tried to run that stroed procedure into query analyzer and it took more than 10 minutes to run. so i thought problem with server. I tried to restart the server and tried to run it. it run in few seconds and send the email as well. but gave only warning message as above.

  -----

  Remote tables are not updatable. Updateable keyset-driven cursors on remote tables require a transcation with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor.

  ------

  Now it works fine. But just wondering what this error means? It is just that there was a problem with server or any other problem?

  thanks,

  vijay

• James Raddock

  Mr or Mrs. 500

  Points: 569

  More actions

  June 4, 2008 at 10:37 am

  #824335

  My guess is there was a lock on the table.

  Check sp_who2 next time this happens if you can catch it in the act. And see if something has the table locked for reading/writing.