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?
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
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?