BI 10 G : How to exclude disabled schedule
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