October 31, 2007 at 6:44 am
I have created System / User Maintenance Plans and scripted the resulting Jobs. If I then delete the Maintenance Plans the Jobs then cease to run. Is there an inherent link between the Jobs and the Maintenance.
What I am trying to do is create a generic script that I can runover any instance of SQL that will create me the required jobs, without haing to have the maintenance Plan there in the first place!.
Regards
Steve
October 31, 2007 at 7:32 am
Yes there is a link between the MPs and the jobs. you get a job scheduled for each MP that you have configured. Just check th command part of the sql script you will find something like xp_maint which refers your MP.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
October 31, 2007 at 7:40 am
So if I delete the entry under Database Maintenance Plans then the Jobs will no longer run?
October 31, 2007 at 7:54 am
Yes of course they will not.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
October 31, 2007 at 8:57 am
The job doesn't contain the steps for the plan. The job just runs a "package" that's set up with the plan. The job is just a trigger for the maintenance plan, which is an SSIS package. Like any other package, the package needs to exist to be executed.
Think of it as a scheduled task in Windows. The task (like a job) just triggers the executable (the plan) to run. If you delete the executable, it won't run.
You can create your maintenance plans with connections to the local server and then they can be moved to all servers and they should run.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply