- 论坛徽章:
- 0
|
有关CRON的配置问题
前阵子在坛子里发帖问用SELECT语句取得当前日期的问题,在liaosnet 大哥的热心帮助下以成功调试过去,代码已经写到如下阶段,我想配置一下CRON服务,让系统每天凌晨4点自动运行,怎么弄啊?哪位大哥能帮下小弟啊?
dbaccess omc_db<<!
unload to "/home/omcadmin/yerui/ttt/pm.txt"
select *
where (*)
and (*)
and (*)
and (*)
(bss_datetimes.date_and_time>=to_char(current year to day - interval(1) day to day,"%Y-%m-%d")||" 09:00")
and (bss_datetimes.date_and_time<=to_char(current year to day - interval(1) day to day,"%Y-%m-%d")||" 10:00")
order by *,*
[ 本帖最后由 tnt4913 于 2007-10-29 17:42 编辑 ] |
|