-
unable to srtart DBMS_JOB . need help
Hello,
we are not able to start dbms_jobs
when i query the database, i see..
select value from dba_scheduler_global_attribute where attribute_name='SCHEDULER_DISABLED';
VALUE
--------------------------------------------------------------------------------
TRUE
I then disable it with - exec dbms_scheduler.set_scheduler_attribute('scheduler_disabled','FALSE');
if i query again, i dont see any values for SCHEDULER_DISABLED and it shows nothing.
how to solve this, we are not able to run any jobs now.
thanks
-
What is the value for job_queue_processes?
Code:
SYS@cadxdc AS SYSDBA> show parameter job_queue_processes
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
job_queue_processes integer 100
-
Here are some queries that will show you what is running for both dbms_scheduler and dbms_jobs.
There are two basic ways to run job in a database dbms_scheduler and dbms_jobs.
Code:
set echo off
col owner format a15
col JOB_ACTION format a50
col JOB_NAME format a30
col JOB_TYPE format a20
col START_DATE format a17
col NEXT_RUN_DATE format a17
col LAST_START_DATE format a17
set linesize 230
set pagesize 0
select 'dbms_scheduler jobs' from dual;
set pagesize 100
select owner, job_name, enabled, job_action,
TO_CHAR(LAST_START_DATE, 'DD-MON-YYYY:HH24:MI') LAST_START_DATE,
TO_CHAR(start_date, 'DD-MON-YYYY:HH24:MI') start_date,
TO_CHAR(NEXT_RUN_DATE, 'DD-MON-YYYY:HH24:MI') NEXT_RUN_DATE
from ALL_SCHEDULER_JOBS
order by enabled, owner, job_name;
col what format a60
col log_user format a35
col interval format a40
col last_date format a18
col next_date format a18
set pagesize 0
select 'dba_jobs' from dual;
set pagesize 100
select job, log_user,
TO_CHAR(last_date, 'DD-MON-YYYY:HH24:MI') last_date,
TO_CHAR(next_date, 'DD-MON-YYYY:HH24:MI') next_date,
interval, broken, what
from dba_jobs
order by 2,3;
set echo on
-
Thanks. The value is 200 for job_queue_processes
-
You should also make sure that the end date is not in the past and that the job has been enabled.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|