You are here

How do I do manually run a job and where are any errors listed in oracle

How do I do manually run a job and where are any errors listed in oracle.

Thanks ...

last run jobs will be at the top running the below command:
select * from all_jobs order by job desc;

run the job:
BEGIN
DBMS_JOB.RUN(79474);
END;
errors show up in the alert log file (located in $ORACLE_HOME/admin/$ORACLE_SID/bdump).

alert log was here for one site for instance: D:\oracle\product\10.2.0\admin\IM\bdump\alert_im.log

Add new comment

Mediawiki

  • Lines and paragraphs break automatically.
  • Allowed HTML tags: <pre><code><br><p>
  • Web page addresses and e-mail addresses turn into links automatically.

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer