Database Administration05 marksSchedule, job and program relationships
Explain relationship between schedule, job and program. Create a Schedule in oracle.
Explain relationship between schedule, job and program. Create a Schedule in oracle. [5]
In Oracle DBMS (specifically Oracle Scheduler), Schedule, Job, and Program are three distinct but closely related objects used to automate database tasks. --- - A Program defines what to do (the action/task to be executed). - It encapsulates the executable unit: a PL/SQL block, stored procedure, ...