-
Title
Schema Browser | Scheduled Jobs tab does not show all jobs when logged in as a DBA. -
Description
User has DBA module license key and is logged into the database as a DBA. Schema Browser | Scheduled Jobs tab does not show all jobs and when the underlying SQL is spooled for this tab, the "USER_SCHEDULE_JOBS" is used and not "DBA_SCHEDULED_JOBS". How to see all jobs when logged in as DBA and have Toad use "DBA_SCHEDULED_JOBS" view?
-
Cause
As default, Schema Browser displays objects, such as Scheduled Jobs, in a specific schema, and initially that schema is user's own schema. Therefore, the USER_SCHEDULE_JOBS view is used to list jobs, because this view holds jobs belonging only to that schema.
-
Resolution
Toad will use DBA_SCHEDULE_JOBS when user selects a different schema in the Schema Browser from the Schema drop down with the following conditions:
1. Check for options:
a) If a DBA role user or a non-DBA user with rights to the DBA views is logged and Tools | Options | Startup | "Check for access to DBA views" option is checked.
b) If a non-DBA with no rights to the DBA views is logged in, then the ALL_SCHEDULE_JOBS view is queried, regardless of the above option checked.
2. Check for filters:
Toad 9.7 has Schema Name filter which allows users to view jobs in all schemas in the Scheduled Jobs tab. Selecting this option will use DBA_SCHEDULE_JOBS. To see all jobs under the Scheduled Jobs tabs, perform the following:
a) Select the Filter Jobs (funnel) icon of the Scheduled Jobs tab.
b) Select "(all schemas)" or "(all except SYS)" options from the Schema Name drop down and hit OK.