I was hopeful I could use DBMS_SCHEDULER for this. Not sure, credentials
are the main issue I think.
I could write scripts I want to run to a table and have an external server
checking for new records and running the .sql from another host.
Not sure if a shared file system is possible. I write an entry to a log on
a shared file system and another server is monitoring same file system and
runs script when commanded.
How would you accomplish this task?
Ultimately I love .sql scripts for some things and don't want to port them
to PL/SQL. I need to be able to run, get output and save, email...this
needs to happen in response to some event within the database.
Thanks!
Ethan