Welcome to Paul Chuks Oracle dba Professional

exec dbms_job.broken( , FALSE); exec dbms_job.run( ); Example: exec dbms_job.broken(111033, FALSE); exec dbms_job.run(111033);

To set up your SQLPATH environmental variable. 1. From run cmd, type regedit and press enter. 2. Under SOFTWARE, expand it, then select ORACLE, expand it, select KEY_Oraclient10g_Home1. 3. On the right pane, double click the SQLPATH. 4. Then add the path for the location of your sql on the hard disk example . 5. And press enter or OK.