patternsqlMinor
Changing MaximumErrorCount when executing maintenance plan
Viewed 0 times
executingmaximumerrorcountplanmaintenancewhenchanging
Problem
I have defined a Maintenance Plan in Microsoft SQL Server 2012. It doesn't execute and it says
Where should change it?
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?
Solution
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:
To allow a task to have multiple errors prior to failing, simply modify the
Having said that, Maintenance Plans are difficult to manage.
Options I recommend using instead:
-
Ola Hallengren has a great replacement solution that is extensible and makes management a breeze.
-
MinionWare Backup - built by DBAs for DBAs.
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:
-
Ola Hallengren has a great replacement solution that is extensible and makes management a breeze.
-
MinionWare Backup - built by DBAs for DBAs.
Context
StackExchange Database Administrators Q#128973, answer score: 2
Revisions (0)
No revisions yet.