Category Archives: Oracle Database

How to check the progress of created Job Scheduler objects in Oracle database.

The Progress of these Objects within the database can be verified by using the following Queries. –To view Scheduler database objects SELECT owner ,object_type ,object_name ,created ,status FROM dba_objects WHERE object_type IN (‘PROGRAM’, ‘JOB’, ‘JOB CLASS’, ‘SCHEDULE’, ‘WINDOW’) ORDER BY … Continue reading

Posted in Oracle Database | Tagged , , , , | 1 Comment

How to schedule a job in Oracle database.

For scheduling any Action in the database we need to create the following tasks Create Scheduling Object Create Program Object Create Job Object Let us go in detail about each task Creating Scheduling Object The schedule determines the time interval … Continue reading

Posted in Oracle Database | 2 Comments