Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Tidal Enterprise Scheduler View

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?

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Tidal Enterprise Scheduler View

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

2 REPLIES
New Member

Tidal Enterprise Scheduler View

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

New Member

Tidal Enterprise Scheduler View

Hi Tracy,


Thank you for your help, that worked!

1354
Views
0
Helpful
2
Replies
CreatePlease login to create content