Name
DBA_SCHEDULER_PROGRAMS
Synopsis
This view shows the named programs in the database.
Column name |
Description |
OWNER |
Owner of the program. |
PROGRAM_NAME |
Name of the program. |
PROGRAM_TYPE |
Type of program; may be PLSQL_BLOCK, STORED_PROCEDURE, or EXECUTABLE. |
PROGRAM_ACTION |
What the program does. For instance, if the program is a stored procedure, then the name of the stored procedure is shown here. If the program is an executable, then the full path is here. |
NUMBER_OF_ARGUMENTS |
Number of arguments of the program, if any. If no arguments, then this shows 0. |
ENABLED |
Whether this is enabled (TRUE/FALSE). |
COMMENTS |
Comments on the program. |
Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.