Oracle Automated Maintenance Tasks

Toad for Oracle
1

I have TOAD 11.6.1.6 with DBA module. I have not been able to find out how to use TOAD to look at the Oracle Automated Maintenance Tasks. I want to see what the tasks area and the parameters used, etc…I am especially interested in the gather stats task.

Any help is appreciated.

Thanks

2

Toad doesn’t have a window specifically for the oracle autotask jobs, but there is a lot of overlap with them and the scheduler windows that does does have. In the Schema Browser, go to the SYS schema and look at the “Scheduler” object types. You can also find some info on the autotask items in the SYS views that are named like DBA_AUTOTASK_*

3

Thanks John for the quick reply. Does new TOAD have GUI view of this automated maintenance tasks?

4

No, sorry.