1 Reply Latest reply: Jul 16, 2013 10:31 AM by spajdy RSS

    Job is running or not

    user13653962

      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