I was wondering if anyone would be nice enough to share a SQL query where I can pull specific fields from the current schedule (to start, I would like to get job names, job ID's and instance). We are using CWA 220.127.116.11 and utilizing a MSSQL DB. I understand I can use the Web Console to pull this information and export it into a text file. The reason I am looking to use a query is because we would like to automate the pulling of the data. We're eventually going to import some of the data into ServiceNow so we can use the data in forms and to allow the customer to perform some scheduling actions.
I have not upgraded to 6.3 yet. I imagine that the tables have been modified, updated, or may be totally different since 6.0x. However, I have attached some queries that I have created/collected over some time using Tidal 5.3 - 6.0x. Feel free to use them if applicable. Most are just selects so you can modify to your needs.
If anyone else has a bank of scripts they use. post them, I'm sure it will help someone.
Note: some of them don't work anymore but I use them to help me formulate other scripts.