Does anyone know if its possible to connect to a scheduled 'saved' job in Oracle. As you know when logging into Oracle, you can choose Tables, Custom Sql, etc. What about if the Custom SQL is stored in a Table like attached - any way to grab that without manually pulling it out by selecting HUGECLOB and manually inserting it into the Custom SQL part?
I do not know of a way to do this. Are there any resources on the Oracle side or other programs that do something like this for comparison?