viernes, 24 de marzo de 2017

TAREAS AUTOMATICAS ORACLE

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: