This discussion is archived
1 Reply Latest reply: Jul 16, 2013 8:31 AM by spajdy RSS

Job is running or not

user13653962 Newbie
Currently Being Moderated

Hi , i am getting following jobs are running in my database , though this job scheduled for last weekend on Sunday only.

 

select *
  from all_scheduler_running_jobs
order by owner , job_name
/

OWNER             JOB_NAME                          JOB_SUBNAME   SESSION_ID SLAVE_PROCESS_ID   SLAVE_OS_PROCESS_ID     RUNNING_INSTANCE    RESOURCE_CONSUMER_GROUP     ELAPSED_TIME              CPU_USED
---------------       -----------------------------        ----------------        ----------------- ---------------------------    ---------------------------------     ----------------------------  -------------------------------------------       ----------------------------   ------------------------------
DM_TGT_TIO   ADMIN_LONG_JOB                                              2131                                       46                                   29720                              1            OTHER_GROUPS                                3 9:46:5.173683000      0 0:26:50.840000000
DM_TGT_TIO   zADMIN_RUN_SPECIFIC_JOBS                            2070                                      45                                   20128                              3             OTHER_GROUPS                                1 14:21:4.222170000   0 0:0:0.210000000

Though there is no session of above jobs session id

 

SQL> Select V.SQL_TEXT , s.*
  2    from GV$SESSION s, gv$sql v
  3   where USERNAME = 'DM_TGT_TIO' and STATUS = 'ACTIVE' and v.sql_id = s.sql_id
  4     and sid in (2131,2070)
  5  /

no rows selected

Is all_scheduler_running_jobs gives you result of current running jobs ? if yes then why its session does not find from above query?

 

Awais

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points