Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Could not complete cursor operation Expand / Collapse
Author
Message
Posted Tuesday, March 08, 2011 4:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 10:09 AM
Points: 189, Visits: 333

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

Add to briefcase

Permissions Expand / Collapse