Your best bet is to talk to an SQL person on your team. Tidal is just a SQL database and the tables can be access natively using SQL statments. Like the following:
SELECT
dbo.jobmst.jobmst_name,
dbo.jobrun.jobrun_duration,
dbo.jobrun.jobrun_time,
finish_time=DateAdd(ss,jobrun_duration,jobrun_time),
dbo.jobmst.jobmst_type
FROM
dbo.jobrun,
dbo.jobmst
WHERE
dbo.jobmst.jobmst_type in (1,2,3,6,8)
and jobmst_name in
('EDW-EU Processing Batch Completed' ,
'EDW-US/CA Processing Batch Completed' ,
'RA_D_US_PROCESS_CHAIN_LOAD_ DCUB' ,
'EDW-US/CA RA Processing Completed')
and dbo.jobmst.jobmst_id=dbo.jobrun.jobmst_id
and jobrun_time is not NULL
and jobrun_time >= '2013/03/24 06:00:00'
and jobrun_time <= '2013/03/25 11:50:00'
ORDER BY
dbo.jobrun.jobrun_time, dbo.jobmst.jobmst_name
Gives me this report.
jobmst_name | jobrun_duration | jobrun_time | finish_time | jobmst_type
----------------------------------------------------------------------------------------------------------------------
EDW-EU Processing Batch Completed | 5 | 2013-03-24 18:00:49.0 | 2013-03-24 18:00:54.0 | 2
RA_D_US_PROCESS_CHAIN_LOAD_ DCUB | 3814 | 2013-03-25 01:31:37.17 | 2013-03-25 02:35:11.17 | 8
EDW-US/CA Processing Batch Completed | 7 | 2013-03-25 04:22:15.0 | 2013-03-25 04:22:22.0 | 2
EDW-US/CA RA Processing Completed | 4 | 2013-03-25 06:34:08.0 | 2013-03-25 06:34:12.0 | 2
----------------------------------------------------------------------------------------------------------------------
Completed at 3/25/2013 9:06 AM
