PL/SQL Documentation views

The scheduler software comes with oracle database views that can be queried by any scheduler user. Oracle users that are not registered as a scheduler user but still are able to query the database views don't see any data.

Back to top 

so_vw_scheduler_users

The database view SO_VW_SCHEDULER_USERS contains all scheduler users.

Back to top 

so_vw_scheduler_privileges

With database view SO_VW_SCHEDULER_PRIVILEGES the scheduler privileges for each scheduler user can be queried.
Scheduler users with the administrator privilege can view the privileges of all scheduler users, otherwise they only see their own privileges.

Back to top 

so_vw_scheduler_queues

The database view SO_VW_SCHEDULER_QUEUES contains all scheduler queues.

Back to top 

so_vw_queues

The database view SO_VW_QUEUES contains all scheduler queues and for each queue a scheduler tasks summary.

The scheduler task totals are a summary based on the tasks visible for the scheduler user who queries the view.
Back to top 

so_vw_scripts

The database view SO_VW_SCRIPTS contains all scheduler scripts created by the scheduler user itself including all granted scripts from other users and the public scripts.

Back to top 

so_vw_script_privileges

The database view SO_VW_SCRIPT_PRIVILEGES contains for each scheduler user all the scheduler scripts it has been granted.

Scheduler users with the administrator privilege can view all grants.
Back to top 

so_vw_script_parameters

The database view SO_VW_SCRIPT_PARAMETERS contains the scheduler script parameters.

Back to top 

so_vw_script_parameter_values

The database view SO_VW_SCRIPT_PARAMETER_VALUES contains for the scheduler script parameters the list of values.

Back to top 

so_vw_tasks

The database view SO_VW_TASKS contains all scheduler tasks for scheduler scripts on which the scheduler user has access.

Scheduler users with the administrator privilege can view all tasks.
Back to top 

so_vw_task_output

The database view SO_VW_TASK_OUTPUT contains the task output.

Back to top 

so_vw_task_parameters

The database view SO_VW_TASK_PARAMETERS contains the scheduler task parameters.

Back to top 

so_vw_task_destinations

The database view SO_VW_TASK_DESTINATIONS contains for each scheduler task every task output destination.

Back to top 

so_vw_scheduler_user_views

The database view SO_VW_SCHEDULER_USER_VIEWS is used by the scheduler client and contains a list of views used on the view window.

Back to top 

so_vw_scheduler_log

The database view SO_VW_SCHEDULER_LOG contains the scheduler server log.

Back to top