In Schema Browser, "Sched. Job" tab, right click to "Create Scheduler Job". The generated SQL shows:
...
BEGIN
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'SCHEMA.PACKAGE'
,attribute => 'STOP_ON_WINDOW_CLOSE'
,value => FALSE);
EXCEPTION
-- could fail if program is of type EXECUTABLE...
WHEN OTHERS THEN
NULL;
END;
About, “WHEN OTHERS THEN NULL”, why does Toad hide the error? If it failed, user needs to know the error message.
WORKAROUND
Please copy and paste the script in the editor, or in the "show SQL window" press the send to editor button and then change it the way you want.
STATUS
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center