oracle下定时执行过程脚本

##用于编译视图和脚本的sql脚本

#Set ORACLEenvironment

ORACLE_HOME=/home/oracle/OraHome1/product

export ORACLE_HOME

ORACLE_SID=oradbyj

export ORACLE_SID

/home/oracle/OraHome1/product/bin/sqlplus vipdl/vipdl123 @/home/oracle/jobs/pro.

sql

/home/oracle/OraHome1/product/bin/sqlplus vipdl/vipdl123 @/home/oracle/jobs/view

.sql

/*****************************************pro.sql *************************************************************/

set feedback off

set heading off

spool /home/oracle/jobs/pro2.sql;

select 'alter procedure 'OBJECT_NAME' compile;' from sys.all_probe_objects w

here OWNER='VIPDL' and OBJECT_TYPE='PROCEDURE' and STATUS='INVALID';

spool off;

@/home/oracle/jobs/pro2.sql;

exit;

/****************************************view.sql*************************************************************/

set feedback off

set heading off

spool /home/oracle/jobs/view2.sql;

select 'alter view 'OBJECT_NAME' compile;' from sys.all_probe_objects where

OWNER='VIPDL' and OBJECT_TYPE='VIEW' and STATUS='INVALID';

spool off;

@/home/oracle/jobs/view2.sql;

exit;

/***************************************crontab**************************************************************/

#

#将以上脚本加入定时触发器

#

20 02 * * * /home/oracle/jobs/Vpmn_sell.sh

30 05 * * * /home/oracle/jobs/Alert_everyday.sh

30 21 * * * /home/oracle/jobs/vipback.sh

30 23 * * 0,1,3,5 /home/oracle/jobs/ftp.sh

30 17 * * * /home/oracle/jobs/pro.sh

/////////////////////////////////////////////////////// 完 ///////////////////////////////////////////////////////////////////////////////////////////

（出处：清风网络学院）