SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error Could not complete cursor operation


Error Could not complete cursor operation

Author
Message
ekknaveen
ekknaveen
Old Hand
Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)

Group: General Forum Members
Points: 337 Visits: 343
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search