cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2409
Views
0
Helpful
2
Replies

Tidal Enterprise Scheduler View

Art Blount
Level 1
Level 1

My company has over 3000 jobs setup in Tidal, most of the jobs are active although some are disable. Has anyone been able to run a query to discover only Active or Disabled jobs?

1 Accepted Solution

Accepted Solutions

Tracy Donmoyer
Level 1
Level 1

You don't need to run a query for this.  You can get the information from the Definitions, Job view.

- Click the Filter (Funnel) icon to display the Job Rule Filter.  Use the "Enabled" field to select enabled (Yes) or disabled (No) jobs.

- Right-click on Jobs and select Group Display, Expand All

- Right-click on Jobs and select Export and you can save the information to a .csv file

To limit the columns that display, right-click on Jobs and select Preferences.  Select the columns you want on your list.

If you insist on running a query, something like this should work:

select jobmst.jobmst_prntname as 'Group'

     , jobmst.jobmst_name as 'Job'

  from jobmst

where jobmst.jobmst_active = 'Y'  /* Y = enabled, N = disabled */

   and jobmst.jobmst_dirty = ''   /* exclude rows marked for deletion */

order by 1, 2

View solution in original post

2 Replies 2

Tracy Donmoyer
Level 1
Level 1

You don't need to run a query for this.  You can get the information from the Definitions, Job view.

- Click the Filter (Funnel) icon to display the Job Rule Filter.  Use the "Enabled" field to select enabled (Yes) or disabled (No) jobs.

- Right-click on Jobs and select Group Display, Expand All

- Right-click on Jobs and select Export and you can save the information to a .csv file

To limit the columns that display, right-click on Jobs and select Preferences.  Select the columns you want on your list.

If you insist on running a query, something like this should work:

select jobmst.jobmst_prntname as 'Group'

     , jobmst.jobmst_name as 'Job'

  from jobmst

where jobmst.jobmst_active = 'Y'  /* Y = enabled, N = disabled */

   and jobmst.jobmst_dirty = ''   /* exclude rows marked for deletion */

order by 1, 2

Hi Tracy,


Thank you for your help, that worked!

Review Cisco Networking for a $25 gift card