Thanks for your response
Rajendra Prasad Sindem, March 24, 2017 - 6:36 am UTC
Thanks for your quick response. Even i had the same thoughts but just wanted to be sure that i am not missing anything.
March 25, 2017 - 3:29 am UTC
glad we could help
Maybe this ....
J. Laurindo Chiappa, March 24, 2017 - 2:00 pm UTC
Hello, Rajendra : maybe you were thinking about the AUTO_DROP attribute in a DBMS_SCHEDULER job - see the Oracle docs (
https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse002.htm#ADMIN12382 is for 11g) : a given job created via DBMS_SCHEDULER will be automatically dropped Only If you specify this attribute when creating the job - by default the auto-drop not will happen, just like Connor said...
Best regards,
J. Laurindo Chiappa
March 25, 2017 - 3:19 am UTC
Nice additional input.