In SQL 2005, is there a way to specify two (or more) different schedules
within one maintenance plan? Or, do I have to create different plans to be
ran on different schedules?
Thank you in advance for your help!> In SQL 2005, is there a way to specify two (or more) different schedules
> within one maintenance plan? Or, do I have to create different plans to be
> ran on different schedules?
You cannot add more than one schedule using the Maintentance Plan Wizard, or
by using the Properties of a created plan. However, with the wizard, you
create a scheduled job. You can add schedules to the job.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment