Example Query
SELECT job_id, nbu_job_id, c.hostname client, s.hostname server, start_date,
finish_date, kilobytes, DECODE(overall_status,0,
'Successful',1,'Partial',2,'Queued', 3,'Running',4,'Failed', NULL) overall_status,
DECODE(was_restarted,0,'No','Yes') was_restarted, vendor_status, orig_vendor_status,
file_pathlist, window_start_date, window_finish_date
FROM TABLE(nbu_rtd.listJobSummaryAfterRestart(${startDate},${endDate},100000,${spHosts},
null,null,null)) t, apt_v_server s, apt_v_server c
WHERE t.server_id = s.server_id
AND t.client_id = c.server_id
ORDER BY t.start_date