- 論壇徽章:
- 0
|
|
求助：在crontab 中配置執(zhí)行tuifu.sh程序不成功；而手工執(zhí)行tuifu.sh程序就能成功； 為什么？怎么解決？謝謝\r\ntuifu.sh源程序如下:\r\n\r\n#!/bin/csh \r\n\r\nset fdate=`/opt/BOCO.NPM/DB/task/ManipDate -f \"%Y%m%d\" -o -24`\r\nftp -n <<! \r\nopen 10.243.170.39 \r\nuser tuifu tuifu \r\nlcd /export/home/npmuser/tuifu/tuifu_data \r\nget GDTF_GROUP_$fdate.csv\r\nclose \r\n!\r\nchmod 666 /export/home/npmuser/tuifu/tuifu_data/GDTF_GROUP_$fdate.csv \r\ncd /export/home/npmuser/tuifu/tuifu_data\r\nvi GDTF_GROUP_$fdate.csv << DEL\r\n:%s/,/\\|/g\r\n:1,1d\r\n:wq!\r\nDEL\r\ncp GDTF_GROUP_$fdate.csv /tmp/GDTF_GROUP_$fdate.csv\r\n\r\ndbaccess npmdb - << EOF\r\ncreate temp table tmp_tuifu_test\r\n(data integer,\r\nproname varchar(255),\r\ntotal_cell integer,\r\nTotal_drop_time integer,\r\nDrop_site_rate float,\r\ntotal_drop_cell integer,\r\ntotal_drop_cell_count integer,\r\ntotal_vip_cell integer);\r\nload from /export/home/npmuser/tuifu/tuifu_data/GDTF_GROUP_$fdate.csv\r\ninsert into tmp_tuifu_test;\r\ninsert into Tpw_drop_site_alarm_sum\r\n(Compress_date,\r\nFirst_Result,\r\nne_id,\r\nNe_type,\r\nsum_level,\r\ns_weekday ,\r\ns_month,\r\ns_day,\r\nTotal_cell ,\r\nTotal_drop_time ,\r\nTotal_stastics_time ,\r\nDrop_site_rate, \r\nTotal_drop_cell ,\r\nTotal_drop_cell_count ,\r\nTotal_vip_cell)\r\nselect\r\ntoday-1,\r\nextend(today-1,year to second),-1489894494,10000,1,\'\',\'\',\'\',total_cell,total_drop_time*60,total_cell*15*3600,\r\ndrop_site_rate/1000,total_drop_cell,total_drop_cell_count,total_vip_cell\r\nfrom \r\ntmp_tuifu_test;\r\nEOF |
|
免費(fèi)注冊(cè)
發(fā)表于 2007-05-24 08:08
