Home Forums SQL Server 2008 SQL Server 2008 Administration Strange Maintenance Plan SubPlans behaviour: each SP runs all the tasks of all other SP at odd times RE: Strange Maintenance Plan SubPlans behaviour: each SP runs all the tasks of all other SP at odd times
j_wentu
SSC Journeyman
Points: 93
More actions
September 17, 2012 at 3:44 am
#1538470
After a lot of tries I found the reason for this behaviour.
I had set the property Disable of each SP to "False" instead of the default "True" and this causes the execution of all the SPs when just one is invoked.