February 15, 2008 at 4:00 am
Hi there, I am still a bit new to SQL Server 2005 and am still on a learning curve. I created a Maintenance Plan to Rebuild Indexes when ever SQL Server Agent starts but am getting a "Job failed" error. Apparently certain tables in the database cannot be re-indexed. What I want to do is tell the plan to go ever the error and carry on with the indexing. Can you help please?!
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
February 15, 2008 at 12:40 pm
If you fire your job from VB, you can add ON ERROR RESUME NEXT clause.
February 18, 2008 at 11:40 pm
Nope, the job is not fired from VB and no it is not a stored procedure or query that I wrote but I used the wizard in SQL Server 2005 to do this but if anyone has a better idea then please give it to me.:hehe:
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
February 19, 2008 at 12:00 am
hi
Whats the error that u r getting. did u check the error log for details.
"Keep Trying"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply