BI Publisher (MOSC)

MOSC Banner

BI 10 G : How to exclude disabled schedule

edited Jun 26, 2014 8:48AM in BI Publisher (MOSC) 1 commentAnswered ✓

Hello,

  I have this query  (on BIP schema 10G) to display scheduled reports :

                   SELECT USER_JOB_NAME,   J.CREATED, J.SCHEDULE_DESCRIPTION

                    FROM  XMLP_SCHED_JOB J 

                    INNER  JOIN QRTZ_JOB_DETAILS  JD ON JD.JOB_NAME=J.JOB_ID   

                     WHERE   Run_TYPE ='R'

I need to filter this query to add a condition to exclude disabled scheduled reports.

your help will be appreciated :-)

Djms

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center