How to disable Auto Task Tunning jobs...

 set lines 180 pages 1000

col client_name for a40

col attributes for a60

select client_name, status,attributes,service_name from dba_autotask_client;

CLIENT_NAME                              STATUS   ATTRIBUTES                                                   SERVICE_NAME

---------------------------------------- -------- ------------------------------------------------------------ ----------------------------------------------------------------

auto optimizer stats collection          DISABLED ON BY DEFAULT, VOLATILE, SAFE TO KILL

auto space advisor                       ENABLED  ON BY DEFAULT, VOLATILE, SAFE TO KILL

sql tuning advisor                       ENABLED  ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL

BEGIN

DBMS_AUTO_TASK_ADMIN.disable(

client_name => 'auto space advisor',

operation   => NULL,

window_name => NULL);

END;

PL/SQL procedure successfully completed.

BEGIN

  DBMS_AUTO_TASK_ADMIN.disable(

    client_name => 'sql tuning advisor',

    operation   => NULL,

    window_name => NULL);

END;  

/

PL/SQL procedure successfully completed.

BEGIN

DBMS_AUTO_TASK_ADMIN.disable(

client_name => 'auto optimizer stats collection',

operation   => NULL,

window_name => NULL);

END;

/

PL/SQL procedure successfully completed.

SQL> select client_name, status,attributes,service_name from dba_autotask_client;

CLIENT_NAME                              STATUS   ATTRIBUTES                                                   SERVICE_NAME

---------------------------------------- -------- ------------------------------------------------------------ ----------------------------------------------------------------

auto optimizer stats collection          DISABLED ON BY DEFAULT, VOLATILE, SAFE TO KILL

auto space advisor                       DISABLED ON BY DEFAULT, VOLATILE, SAFE TO KILL

sql tuning advisor                       DISABLED ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL

SQL>