Introduction We often want to run pre-defined jobs at different schedules. Oracle Database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for scheduling pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs …
How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER Read More »
The post How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER appeared first on Techgoeasy.
This post first appeared on Techgoeasy - Learn Oracle, PHP, HTML,CSS,Perl,UNIX, please read the originial post: here