BROKEN JOB - Reseting and running broken job
exec dbms_job.broken( , FALSE); exec dbms_job.run( ); Example: exec dbms_job.broken(111033, FALSE); exec dbms_job.run(111033);
Posts
SQLPATH -how to set up your sql to make use of sqlpath variable
- Get link
- Other Apps
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.