Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wentu
Starting Member
3 Posts |
 Posted - 2012-09-14 : 09:52:41
|
| HelloI have a problem with scheduling a Maintenance Plan (MP) with 3 subplans (SP).SP1 is scheduled to run hourly, SP2 daily at 7.00 and SP3 on sundays at 8.00Reading MP history I see that what happened (I know it seems crazy) is:today at 11:00: SP1 runs and executes all the tasks of SP1 SP2 and SP3today at 12:00: SP2 runs and does the sametoday at 13:00: SP3 runs and does the sametoday at 14:00: SP1 runs and does the sameFrom the job Activity monitor, SP1 has last run time at 14, SP2 and SP3 are *never* been executed.All of the SP are scheduled correctly in the Job Activity Monitor (SP2 for tomorrow at 7, SP3 for next sunday at 8)Do you have any idea what is happening?Thankx a lotWentuPS.: I am now aware I put this in the wrong forum as I am working with SQL Server 2005. I am sorry for the mistake, is there a way I can move this thread in the correct place? |
|
|
Wentu
Starting Member
3 Posts |
Posted - 2012-09-17 : 05:43:49
|
| 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. |
 |
|
|
|
|
|
Peculiar (=crazy) subplans scheduling behaviour