Page History

-- QUERY_1 : Provides overview status of audit requests during the last 24 hours
select l.jobid, l.userid, l.status, l.servername, d.status, d.userid, d.destination_url, d.send_error_count
, d.send_date, d.send_error_message 
from job_queue_list l
left outer join job_queue_destination d on d.jobid = l.jobid
where l.jobid >= to_char(sysdate-1,'yyyymmdd') and r.jobid < to_char(sysdate+1,'yyyymmdd')
and l.userid like '%@TRAN%'
order by 1;

-- QUERY_2 : Identifies output for an audit
select r.jobid, r.INT_SEQ_NO, count(o.jobq_seq_no) from job_queue_run r
left outer join job_queue_out o on o.jobq_seq_no = r.INT_SEQ_NO
where r.jobid >= to_char(sysdate-1,'yyyymmdd') and r.jobid < to_char(sysdate+1,'yyyymmdd')
and r.userid like '%@TRAN%'
group by r.jobid, r.INT_SEQ_NO order by 1;

-- QUERY_1 : Provides overview status of audit requests during the last 24 hours
select l.jobid, l.userid, l.status, l.servername, d.status, d.userid, d.destination_url, d.send_error_count
, d.send_date, d.send_error_message 
from job_queue_list l
left outer join job_queue_destination d on d.jobid = l.jobid
where l.jobid >= convert(varchar(8), getdate()-1, 112) and r.jobid < convert(varchar(8), getdate()+1, 112)
and l.userid like '%@TRAN%'
order by 1;

-- QUERY_2 : Identifies output for an audit
select r.jobid, r.INT_SEQ_NO, count(o.jobq_seq_no) from job_queue_run r
left outer join job_queue_out o on o.jobq_seq_no = r.INT_SEQ_NO
where r.jobid >= convert(varchar(8), getdate()-1, 112) and r.jobid < convert(varchar(8), getdate()+1, 112)
and r.userid like '%@TRAN%'
group by r.jobid, r.INT_SEQ_NO order by 1;