SQL>
SELECT JOB_NAME, SCHEDULE_NAME, SCHEDULE_TYPE, ENABLED FROM DBA_SCHEDULER_JOBS WHERE PROGRAM_NAME = 'GATHER_STATS_PROG'; JOB_NAME SCHEDULE_NAME SCHEDULE_TYPE ENABLED ---------------- ------------------------ -------------- ------- GATHER_STATS_JOB MAINTENANCE_WINDOW_GROUP WINDOW_GROUP TRUE
DBA_AUTOTASK_TASK
select * from DBA_AUTOTASK_TASK
PACKAGE DBMS_AUTO_TASK_ADMIN
No hay comentarios:
Publicar un comentario