Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to disable a running job

623150Sep 16 2008 — edited Dec 2 2008
Dear All,

i have created a job using below code

begin

DBMS_SCHEDULER.CREATE_JOB (

job_name =>'create_dir_test2',

job_type =>'executable',

job_action => 'c:\winnt\system32\cmd.exe /c mkdir c:\test\test1',

enabled =>true,auto_drop => true

*);*

end;

The Job was created and its state showed that it is running but now i want to disable this job but i am not able to do that

Tried to run the following code but it just hangs and does't work

begin
dbms_scheduler.disable('CREATE_DIR_TEST2',true);
end;


begin
dbms_scheduler.stop_job('CREATE_DIR_TEST2',TRUE);
end;

any help will be appreciated

Regards,
Kashif Ali
This post has been answered by Rnr-Oracle on Sep 16 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 30 2008
Added on Sep 16 2008
3 comments
2,662 views