Re: How do you kill a job of a user scheduled job?

On Sat, 14 Jun 2003 13:30:52 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>On Sat, 14 Jun 2003 10:37:06 GMT, Peter <peter_at_nomorenewsspammin.ca>
>wrote:
>
>>How do you kill a job of a user scheduled job that is listed in
>>users_job table?
>>
>>Thanks.
>
>
>dbms_job.broken(<job_number>)
>
>
>And you have to be connected as the owner of the job
>

I tried that before. the job is stopped. But

        select job, what from user_jobs;
still returns a list of jobs. How do I remove all the jobs from the user_jobs table?

Thanks

>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
Received on Sun Jun 15 2003 - 02:55:36 CDT