DBMS_JOB and 19c – code changes needed
Sep 2021: Important update at tail of this post Here’s a “gotcha” brought to my attention by one of our
Tag: dbms_scheduler
How to change Scheduler maintenance windows
There are a few possible reasons why you might be one of those people why you might be using your
Checking status of the Database Scheduler
When the scheduler came into existence in Oracle 10g, there was a cool API call that could be used to
DBMS_JOB – the joy of transactions
This is a followup to yesterdays post on DBMS_JOB and is critical if you’re upgrading to 19c soon. Mike Dietrich
DBMS_JOB – watching for failures
I had a friend point this one out to me recently. They use DBMS_JOB to allow some “fire and forget”
Long running scheduler jobs
One of the nice things about the job scheduler in the Oracle database is the easily interpreted interval settings you
Learning is not a spectator sport 