Situation In Oracle Database 12c, we have the long-missed feature of DBMS_SCHEDULER job type “BACKUP_SCRIPT”, that allows us to create backup jobs without creating them as an OS file, and without need for a wrapper script that’s called by a job type EXECUTABLE (as we usually did that in the last years). Sometimes we also […]
Tag: dbms_scheduler
Oracle: Executing an OS command from PL/SQL – ICMP ping from database
Executing OS commands from SQL or PL/SQL is easy as long as you are in SQL*PLUS – just do a host command. But I must confess, that this is a really useless hint. 🙂 Much more interesting is to execute an OS command with a DBMS_SCHEDULER job, but this is not possible in every case, […]
Oracle: Remove scheduler jobs in a loop
If there are too much scheduler jobs in an Oracle database, the CJQ process may die unexpectedly. This has nothing to do with job history, not, it’s the number of jobs known to the system. In my experience, the critical number is somewhere around 32.000 in 10.2 64bit. By the way, that’s the solution for […]