-
scheduler job didn't get created even it was executed successfully
below is my code:
both (program and job) were executed without error but when I check dba_scheduler_jobs, I can't see the job at all, what did I do wrong?
begin
dbms_scheduler.create_program
(
program_name => 'REFRESH_SCRIPT',
program_type => 'EXECUTABLE',
program_action => '/usr1/oracle/scripts/refresh.sh',
enabled => TRUE,
comments => 'calling shell script');
end;
/
begin
dbms_scheduler.create_job
(
job_name => 'REFRESH',
program_name => 'REFRESH_SCRIPT',
comments => 'job to start refresh',
enabled => TRUE);
end;
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|