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