Tidal Query to export all runbook tab inmformation.

[Michael Begler]

I have Tidal 5.3.1 wth a sql database. I'm looking for a query to provide me with all the runbook information for all 2700 job.

[Derrick Au]

Hi Mike,

For this query, you can run the below to pull in the Job ID, parent name, jobname, and then runbook:

SELECT  jobmst.jobmst_id, jobmst.jobmst_prntname, jobmst.jobmst_name, jobmst.jobmst_runbook FROM jobmst

Regards,

Derrick Au