Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Strange Maintenance Plan SubPlans behaviour: each SP runs all the tasks of all other SP at odd times...


Strange Maintenance Plan SubPlans behaviour: each SP runs all the tasks of all other SP at odd times

Author
Message
j_wentu
j_wentu
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 74
Hello

(SQL Server 2005) I 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.00

Reading MP history I see that what happened (I know it seems crazy) is:
11: SP1 runs and executes all the tasks of SP1 SP2 and SP3
12: SP2 runs and does the same
13: SP3 runs and does the same
14: SP1 runs and does the same

From 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 lot

Wentu
j_wentu
j_wentu
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 74
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search