Maintenance Plan in SQL 2005

Question

Hi,

I have created maintenance plan in SQL server 2005.Which will take the DB Log backup for every 2 Hrs. Start at 1:00:00 AM and End at 12:59:59 PM.

Now I want to restrict this job that should not run between 1:00:00 AM to 3:00:00 AM.

How to do this?

Answer 1

Hi,

Under SQL Server Agent, you can find the job that was generated for the execution plan.

Double click it, then go to schedules.

Under the schedule menu, you can change the start and end times.

Change the start time to 3:00 AM, and that should do the job.

---

My Blog: www.dbnewsfeed.com