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 )
call "SYSADMIN.updateSchedule" ( "id" => 16, "chainString" => '1=SUCCESS |18=SUCCESS' ) ;; |
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
Comments
0 comments
Please sign in to leave a comment.