Showing posts with label Scheduler. Show all posts
Showing posts with label Scheduler. Show all posts
Wednesday, August 7, 2024

How to find a failed job in the data dictionary tables

›
My adrci output showed a failed job (abbreviated): ADR Home = /u01/oracle/diag/rdbms/mydb01/mydb01: *************************************...
1 comment:
Tuesday, May 18, 2021

How to find the opening and closing time for the maintenance windows in an Oracle database

›
To see the last 7 days of opening/closing time for the maintenance windows, use this query: SELECT window_name,to_char(start_time,'dd...
Friday, January 8, 2021

How to disable a scheduler job in a another schema

›
Use the syntax connect system set serveroutput on EXECUTE DBMS_SCHEDULER.DISABLE(name=>'SCOTT.UPDATE_COMMISIONS'); You canno...
Tuesday, February 12, 2019

How to remove a job from the job queue

›
Today I saw the following error message in the alert log of my database: 2019-02-12T13:27:30.506714+01:00 Errors in file /u01/oracle/diag/...
Tuesday, April 10, 2018

How to change the start time for a maintenance window

›
For example, if you want to change the start time for the MONDAY_WINDOW from the default 22:00 to 23:59, use the following syntax: BEGIN D...
Tuesday, February 16, 2016

How to remove dbms_scheduler jobs

›
To delete an obsolete scheduler job, use the procedure dbms_scheduler.drop_job procedure. In a recent case, a large number of obsolete dbm...
Wednesday, May 27, 2015

How to create a stored procedure for partition maintenance, executed by the Oracle Scheduler.

›
I needed to setup a small job that would remove partitions from a table with records older than 35 days. The procedure should be flexible e...
1 comment:
Wednesday, April 29, 2015

How to execute a stored dbms_scheduler job

›
In sqlplus, execute the following: execute dbms_scheduler.run_job('CHANGE_PERMS',TRUE);
Thursday, July 10, 2014

How to drop stuck purge job created through DBMS_AUDIT_MGMT

›
In the process of implementing automatic purging of the audit trail, I came across a problem that I was really puzzled by: In the debugging...
2 comments:
Tuesday, July 8, 2014

How to purge the log entries for a specific dbms_scheduler job

›
exec dbms_scheduler.purge_log(log_history=>0, job_name=>'YOUR_JOB_NAME'); Zero is actually default for log_history, it doesn...
Saturday, October 19, 2013

How to use the dbms_scheduler package to collect intermittent statistics on volatile tables

›
In the following example I am using the dbms_scheduler package to analyze certain volatile tables every hour: BEGIN SYS.DBMS_SCHEDULER.C...