dbms_scheduler创建job

1.创建目录和需要的shell和txt
[root@lk ~]# mkdir /job
[root@lk ~]# chown oracle.oinstall /job
[root@lk ~]# su - oracle
[oracle@lk ~]$ cd /job
[oracle@lk job]$ ls
[oracle@lk job]$ vi a.sh
[oracle@lk job]$ chmod +x a.sh
[oracle@lk job]$ cat a.txt
cat: a.txt: No such file or directory
[oracle@lk job]$ touch a.txt
[oracle@lk job]$ cat a.sh
#!/bin/bash
echo "a" >> /job/a.txt

[oracle@lk job]$ ./a.sh
[oracle@lk job]$ cat a.txt
a
[oracle@lk job]$ ./a.sh
[oracle@lk job]$ !cat
cat a.txt
a
a

2.创建job
exec dbms_scheduler.create_program(program_name=>'backup_level0',program_type=>'EXECUTABLE',program_action=>'/job/a.sh',enabled=>true,comments=>'oracle database rman level 0 backup');
exec dbms_scheduler.create_schedule(schedule_name=>'bl0s',repeat_interval=>'FREQ=MINUTELY; INTERVAL=0;',comments=>'oracle database rman level 0 backup schedule 1');
exec dbms_scheduler.create_job(job_name=>'backup0',program_name=>'backup_level0',schedule_name=>'bl0s',enabled=>true);
exec dbms_scheduler.run_job(job_name=>'backup0');

[oracle@lk job]$ cat a.sh
#!/bin/bash
echo "a" >> /job/a.txt

[oracle@lk job]$ cat a.txt
a
a
a
a
a

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29477587/viewspace-1432398/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29477587/viewspace-1432398/