Not able to disable a running job
623150Sep 16 2008 — edited Dec 2 2008Dear 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