Re: How to run Job in Oracle after failed

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Fri, 19 May 2006 13:54:10 +1000
Message-ID: <MPG.1ed7ec6e2a7f9bd99897de@news.readfreenews.net>

resant_v_at_yahoo.com says...

> I just migrate from SQL Server to Oracle. I have a question when I work
> with job in Oracle, and try to use this forum to asking it.
> I ask this question is because I don't understand about Job in Oracle,
> not want to compare that.
> So, please don't fill me with a debate which is better between SQL
> Server or Oracle...
>
> At SQL Server, if a job failed, that job will still run again on next
> schedule, but not in Oracle.
> I think this beacuse Oracle job use Interval, so if once it failed,
> will not run again on next schedule. Is it right? How to fix that
> problem?

As many will advise you, when you post a problem or seek advice on this forum, please specify your platform and version.

Depending on your version, look at using DBMS_SCHEDULER instead of DBMS_JOB GM Received on Thu May 18 2006 - 22:54:10 CDT