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.
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?
Go to Solution.
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'
where jobmst.jobmst_active = 'Y' /* Y = enabled, N = disabled */
and jobmst.jobmst_dirty = '' /* exclude rows marked for deletion */
order by 1, 2
Thank you for your help, that worked!