How to specify within the job manager to execute (for example)
a. Full backup every day at 9pm.
b. Differential every 4 hours.
c. Tlog every hours.
N/A
WORKAROUND 1:
The steps can be created as separate subplans within the parent MP. These sub plans can then be setup with different schedules
Steps in detail;
1. Create a new Maintenance Plan to perform full backup of Northwind.
2. Click on the Sub plan, add with a name 'differential'
a. Enable the job and setup differential schedule for backup.
b. See new differential in the drop down tree.
c. Select differential | click on backup database (on right side)
d. Change from FULL to Differential and select Northwind.
e. Do the same for Tlog setup, go to steps 2 above.
f. Click on Job manager icon to view all three tasks.
WORKAROUND 2:
In Job Manager, highlight and click the job, you can modify the schedule there as well.
