manual start of dependent schedules

view1, view2 and view3

Lets have a daily schedule on 12:00 for view1, where view2 depends on, and where view3 depends on (Schedule 1) the schedule of view2 ( Schedule 16):

 

Create second schedule on the optimization of view1 which is type "Run daily", and disable this Schedule

Click on this created schedule and note the Schedule id ( 18 in this case ) 

Click on the first dependent schedule in the chain and note the Schedule id ( 16 in this case )

Open an SQL Editor and execute the following command, where ID is the scheduleid of the first dependent schedule, and the chainString consists of the already existing dependent Expression ( 1=SUCCESS in this case ) concatenated with 

| 18=SUCCESS which means, that this schedule should be dependent on our second schedule as well ( OR condition )

Now this schedule will look like this:

If you want to start your chain manually, edit the second schedule created, enable it, and set "Start job at:" to one minute after the current time. 

After the job is done, disable the second schedule again