12.1.0.2
We're getting hit with a performance issue with SQL coming from enterprise manager chewing CPU due to SQL hitting dba_scheduler_job_Details.
now theres a way round it here....
|
This works. Subsequently decided, We want to group our jobs into 3 different types of job retention, 1 day, 7 days, 1 month. We can do this with the dbms_scheduler.set_attribute. If I then run get_Atribute I can see that setting on a single job. we have a lot of jobs. I want to see all the attributes on all the jobs. We can run this to get a single attribute of a single job.
SET SERVEROUTPUT ON
DECLARE
get_name VARCHAR2 (50);
v_value VARCHAR2 (50);
get_attribute VARCHAR2 (50);
BEGIN
get_name := 'JOB_NAME';
get_attribute := 'MAX_FAILURES';
DBMS_SCHEDULER.get_attribute (name => get_name,
attribute => get_attribute,
VALUE => v_value);
DBMS_OUTPUT.put_line (get_name || ' = ' || v_value);
END;
Im looking to see is there a table somewhere that stores all the attributes for all the jobs. Anyone know is there one?