Tag Archives: scheduler

Scheduler Enhancements in Oracle Database 12c

I’ve spent the last couple of days playing around with the scheduler enhancements in Oracle 12c. Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) I guess the big news is the new “script jobs”, which are pretty cool. This kind-of passed me by until Brynn Llewellyn mentioned them at UKOUG in his Multitenant […]

SQL Developer 3.1 : Scheduler Support…

I had a play around with the scheduler support in SQL Developer 3.1 today. I’m late to the party because most of it has been there since 3.0, but what the hell. SQL Developer 3.1 Scheduler (DBMS_SCHEDULER) Support It’s more of an opinion piece, so it started as a blog post, but it got too […]

New scheduler stuff in 11gR2…

There are some nice new features in the scheduler in 11gR2. I’ve written about them here: Scheduler Enhancements in Oracle Database 11g Release 2 Remote Scheduler Agent Installation for Oracle 11g Release 2 Remember, there was already a bunch of new stuff added in llgR1, so there’s a lot of whiz-bang stuff if you are […]

A Tale of 4 Schedulers…

A long time ago in a galaxy far, far away, there was only one Oracle scheduler. It was managed using the DBMS_JOB package and the job information was stored in a single table. SELECT table_name FROM dba_tables WHERE owner = ‘SYS’ AND table_name LIKE ‘JOB$%’ ORDER BY table_name; TABLE_NAME —————————— JOB$ 1 row selected. SQL> […]