Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Error Could not complete cursor operation Expand / Collapse
Posted Tuesday, March 8, 2011 4:23 AM


Group: General Forum Members
Last Login: Monday, March 14, 2016 9:29 PM
Points: 193, Visits: 343


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
Post #1074682
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse