No, it runs just fine. That's the odd part. It runs fine when I open a SQL window and then execute the code, but when it is in Job mode, nothing happens.
I have a technical question.
I would like to learn how to set up a weekly scheduled job to run over a link from one database to another. I'm using Oracle 9.2.0.7 on both servers using PL/SQL Developer (see configuration below)
I don't know how to do this, since I've never set up a job before...