job scheduler

Execute batch file using Oracle Job Scheduler

Karan Balkar
Hey everyone! The Oracle database includes a built-in scheduler that allows scheduling functions and procedures that can be called from any PL/SQL program. The DBMS_SCHEDULER package introduced in Oracle 10g helps to create, run and monitor jobs. In addition, one can also define a job to execute a batch (.bat) file. In order to run an external job, you need to enable and start the OracleJobScheduler service on the database server.