Re: Stop a job via SQL/Stored procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon-verwijderdit.nl>
Date: Wed, 28 Aug 2002 10:27:42 +0200
Message-ID: <ea2pmu4t0hl41v0ce0l3dumf6um672ol5f@4ax.com>

On 28 Aug 2002 00:46:56 -0700, jabelsc_at_yahoo.com (Abel Suarez) wrote:

>Hi everybody!
>
> Is there a way to stop/start an Oracle job via SQL or a stored
>procedure? I need to do it through a java program. I'm using Oracle
>8.1.6.
>
> THanks in advance.
>
> Abel S.

dbms_job.broken(<id>,TRUE)

simple is it not? Just read up the dbms_job doco.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 28 2002 - 03:27:42 CDT

This message: [ Message body ]
Next message: Norman Dunbar: "Help! ORA-01658 on import, and with plenty of space"
Previous message: Howard J. Rogers: "Re: utl_file_dir showing up empty"
In reply to: Abel Suarez: "Stop a job via SQL/Stored procedure"
Next in thread: Vladimir M. Zakharychev: "Re: Stop a job via SQL/Stored procedure"
Reply: Vladimir M. Zakharychev: "Re: Stop a job via SQL/Stored procedure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US