2

I have defined a Maintenance Plan in Microsoft SQL Server 2012. It doesn't execute and it says

   DTS_W_MAXIMUMERRORCOUNTREACHED.
 The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure.
 This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors////

Where should change it?

1

Each task in a Maintenance Plan has a variety of options that can be changed by right-clicking the desired task, then selecting the "Properties" option from the context-menu. As in:

enter image description here

To allow a task to have multiple errors prior to failing, simply modify the MaximumErrorCount property I've highlighted above to some number greater than 1.

Having said that, Maintenance Plans are difficult to manage.

Options I recommend using instead:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.