Performing and timed Oracle stored procedures under Linux

Executes the sh of the stored procedure. /oracle/.bash_profile/oracle/bin/sqlplus qd/qd@info<<! exec qd.cjm_duanx_tx; Exit!

Timed execution of stored procedures using timers
View Timer:

Crontab-l

CRONTAB-E Edit Timer

I insert a new
: w! Save
: q! Exit

The contents are as follows:
For example, 8 in the morning, the shell is as follows:

* * * sh/data/work/jhxt/day_sh/cj_oracle.sh

This is a method of timing execution of stored procedures at the OS system level and, of course, the job, which is not described in detail here.