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

Posted by Wentu on Server Fault See other posts from Server Fault or by Wentu
Published on 2012-09-14T14:15:18Z Indexed on 2012/09/14 15:39 UTC
Read the original article Hit count: 295

Filed under:

sql-server-2005

|

maintenance-plan

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

© Server Fault or respective owner

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More

Related posts about maintenance-plan

Unable to back up SQL Server databases using a maintenance plan

as seen on Server Fault - Search for 'Server Fault'
I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select all databases, and choose a path to back up to. When I save and try to execute this plan, I get the… >>> More
Unable to back up SQL Server databases using a maintenance plan

as seen on Server Fault - Search for 'Server Fault'
I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select all User databases, and choose a path to back up to. IMAGE in http://www.freeimagehosting.net/uploads/16be7dce43… >>> More
Make your Website Up and Running With Proper Website Maintenance Plan

as seen on Article City - Search for 'Article City'
Electronic commerce or e-commerce simply refers to a wide range of online businesses activities for products and services and nowadays E-commerce has entirely overturned the system of communication a... [Author: Alan Smith - Web Design and Development - March 21, 2010] >>> More
Effortless Financial Transaction For Increasing Revenue By Website Maintenance Plan

as seen on Article City - Search for 'Article City'
While going for a new one or require performing changes to an existing site then following a good maintenance process is of utmost importance to manage a website in business because an increasing num... [Author: Alan Smith - Web Design and Development - April 02, 2010] >>> More
Running "Rebuild Index" maintenance plan with "Online indexing"

as seen on Server Fault - Search for 'Server Fault'
Hi I am using Windows Server 2003 SP 2 and SQL Server 2005 Enterprise edition I am creating a "Rebuild Index" job for a particular database and I am successfully able to run the job. But when I try to enable the "Keep index online while rebuilding" option, the job does not execute successfully… >>> More