Export All Tidal Jobs With Dependancies

[youngjeCisco]

I'm in need of an export of all active jobs on our Tidal scheduler, and some of the information I need isn't available through the GUI.  I know my way around SQL, but I'm not familiar with the table structure, and I'm hoping someone here can help.

I'm in need of the following information: JobName, StartDate, StartTime, JobQueue, Frequency, and their Dependencies

Any assistance would be greatly appreciated.

Thanks,

JY

[ikkynikinae]

Rather than going to the DB, I believe you can achieve this by exporting the job definitions to CSV from the console.  

In this case, JobQueue is the only one I'm not sure is a field that is available when you export.

[Derrick Au]

JY, ikkynikinae,

Queue is actually present in the export. It would be cumbersome to click on each individual job to look at the direct predecessors and successors for each job in the activity window, and then go back into the definitions to look for the frequency (how often the job runs). This is query is a little bit tricky as you will need to query against the jobmst table against jobmst table itself, but definitely do-able. 

BR,

Derrick Au