Database Administration · Unit 9
Job Scheduling and Automation
Exam-focused notes for Job Scheduling and Automation (Database Administration, BIT352): what the TU syllabus asks and how it has actually been tested, with 4 solved past questions from this unit.
What this unit covers
- Job scheduling in oracle database
- DBMS_SCHEDULER functionality
- Scheduler components
- Schedule definition and creation
- Job and job classes
- Program definition and relationship
- Event-based schedule creation
- Schedule, job and program relationships
Event-based schedule creation
How event based schedules are created? Explain. [5]
An event-based schedule (also called an event-driven schedule) is a scheduling approach where task execution is triggered by the occurrence of specific events rather than by a fixed time interval or clock tick. The scheduler responds to events as they happe...
Full solved answer →Job scheduling in oracle database
What is Job Scheduling in oracle database? How DBMS_ SCHEDULER Works? Explain the different component of scheduler. [5]
Note: Reference notes were not available for this topic. The following answer is based on standard Oracle Database documentation and is correct for TU BSc CSIT curriculum. --- Job Scheduling in Oracle Database is the process of automating the execution of d...
Full solved answer →Job and job classes
What is Job and Job classes? Create an event-based schedule in Oracle. [5]
A Job is a scheduled task or unit of work that Oracle Scheduler executes at a specified time or interval. A job defines: - What to run (a PL/SQL block, stored procedure, or executable) - When to run (a schedule or specific time) - How to run (priority, logg...
Full solved answer →Schedule, job and program relationships
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 ...
Full solved answer →Make Unit 9 stick
Practice BIT352 with flashcards & quizzes