How to display list of currently running "Scheduled Jobs". Custom filter not be saved. (4229638)

How can the schema browser list of scheduled jobs be set to only display jobs that are currently running?

Can this sort of view be set up in the schema browser and be saved for subsequest reference?

Lists in the schema browser has filter options. Filters can be created. Currently there is a defect with saving custom filters.

To Create a Filter:

In schema browser's "Scheduled Jobs" list, click the filter icon on the toolbar just above the list of objects.

Since there is no specfic option in the gui to show currently running jobs, choose to enable "view/edit query before executing" and "custom filter (use view/edit query to adjust)". 

In the "View/edit shcema browser query" window, adjust the script to add the condition to filter on.

Sample:

Select P.JOB_NAME, P.JOB_TYPE, O.OBJECT_ID, P.JOB_CLASS, P.ENABLED, P.COMMENTS, O.LAST_DDL_TIME, O.CREATED, P.STATE, CAST(P.NEXT_RUN_DATE AS DATE) next_run_date
      ,:own owner
      ,schedule_type
FROM   SYS.USER_SCHEDULER_JOBS P, sys.USER_OBJECTS O
WHERE  O.OBJECT_NAME = P.JOB_NAME
AND    O.OBJECT_TYPE = 'JOB'

-- This is the condition added.

AND  p.state = 'running'

The filter will be applied to the list.

Saving the Filter:

The current defect is that the filter cannot be saved as expected.

WORKAROUND:

None. After the filter is created, it will only display that once. When the window is changed the filter is lost. When going back to that list, the filter will need to be created again.

STATUS:

Waiting for fix in a future version of Toad for Oracle.