Error Could not complete cursor operation

• ekknaveen

  SSCrazy

  Points: 2317

  More actions

  March 8, 2011 at 4:23 am

  #247760

  Hi,

  I had scheduled a job which is running multiple procedures. The job is scheduled at 23:30 daily and it is running successfully but weekly once it 26/2/2011 then 05/03/2011 it is failed with the below error:

  "

  Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943) Cursor is not open. [SQLSTATE 42000] (Error 16917) Cursor is not open. [SQLSTATE 42000] (Error 16917). The step failed."

  There are 2 maintenance jobs are scheduled to be triggered weekly once.

  Integrity Checks Job for DB Maintenance Plan 'All DB Integrity & Optimization' which is scheduled at 12:00 and is running on 26/2/2011 and 05/03/2011

  Optimization job for DB maintenance plans 'All DB integrity and Maitenance': This is scheduled at 2:00 and ran on 27/2/2011 and 6/3/2011.

  Can anyone tell me what should be the reasons and how to make the job to run successfully as it is giving problem only 1 a week.

  Thanks in advance

  Naveen