...
This is a small follow up exercise showing user use of embedded triggers.
These are trigger expression embedded within the scripts using the --wait child command.
Whilst the expression is not true, then the job will hold.
Where possible you should give preference to triggers on the definitions, since these are checked on creation, whereas embedded triggers are checked at run time.
...