02-11-2016 01:40 PM - edited 03-01-2019 09:20 AM
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
03-22-2016 09:41 AM
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.
03-22-2016 12:08 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide