unable to srtart DBMS_JOB . need help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: unable to srtart DBMS_JOB . need help

  1. #1
    Join Date
    Feb 2001
    Posts
    114

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    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
    this space intentionally left blank

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    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
    this space intentionally left blank

  4. #4
    Join Date
    Feb 2001
    Posts
    114
    Thanks. The value is 200 for job_queue_processes

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    You should also make sure that the end date is not in the past and that the job has been enabled.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width