Toad World® Forums

Changing ownership of Oracle Scheduled jobs.

Oracle 11g

We have a lot of scheduled jobs that were created by an admin who did not use a continuity account like ADM. He owned the jobs.

The admin is no longer with us.

If I lock the old admin in the user table jobs fail.
Trying to find out how to change ownership of the jobs without creating them again.

Looked on TOAD but no luck.
Any help is appreciated.

There is no way in Oracle to just change ownership of database objects, including jobs.

The easiest way to create things in another schema is rt-click them in the schema browser, then choose “create in another schema” and answer the questions.

Once you are sure they are set up right in the new schema, you can disable or drop them from the old.

Thank you John.