cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

697
Views
0
Helpful
1
Replies
Carol Kelpin
Beginner

list all tidal jobs from a report

Is there a way to list all Tidal Jobs, what scripts they run, and where all those scripts are located beyond opening each and every individual job and searching for that information?  Is there not a report we can run?

1 REPLY 1
Michael Durette
Beginner

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

Content for Community-Ad