Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
select rs_execution_start_time,
rs_execution_end_time,
rs_execution_end_time - rs_execution_start_time,
rdp_cardinality,
from MCKESSON_SND_SPM.run_data d
join MCKESSON_SND_SPM.run_status_data s
on rd_id = rs_id
left join MCKESSON_SND_SPM.run_data_profile p
on rd_id = rdp_id
left join MCKESSON_SND_SPM.utl_process_type
on rd_type = process_type_id
where rd_definition_id = 9691258
and rd_status in (select 1 from dual)
order by rd_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment