I need a simple script to create a job that executes a procedure for an application user in oracle. The procedure copies the data from production to dev. I have a database link and expdp set up - I can run the refresh manually but have not been able to create a job to run the procedure. - I get ora 31626 - job does not exist. The person who created this procedure is no longer with us - they created the job as a scheduled job in toad - I have never used that to create a job - only have used dbms_job.submit to run a job.
oracle 10g on aix