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 [...]
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 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> [...]