DB Console
We can use DB Console's Job Scheduler admin pages to generate the code; the resulting code was given above. Here is how you can build the programs in DB Console. If you want to use DB Console, log in and navigate to the Server tab in DB Console as shown in the following screenshot:
Select the Programs link under the Oracle Scheduler header, and then hit the Create button as shown in the following screenshot:
In the following dialog box that appears, enter the names and code as specified by using the values suggested earlier:
Repeat this for the other two programs. In the end, we should have the three programs—SHUTDOWN
, COPYFILES
, and STARTUP
—in the programs overview as shown in the following screenshot. See to it that MARVIN has all the three programs as discussed.
Chain definition
Did you see the status of the Enabled flag in the program creation part of this screenshot? They are all in the enabled state. We can use a chain only if all of its components are in an enabled state...