Crontab环境配置问题 - (cx_Oracle)

while True: if IS_OPEN: logging.info("-------------------start------------------------------") start_time1 = time.time() try: # 使用 with 语句管理数据库连接和游标 with cx_Oracle.connect(user='acme', password='acme', dsn=dsn) as connection: with connection.cursor() as cursor: logging.info("SQL查询5个状态为0的lot任务---开始") # TODO 需要改逻辑，如何查5个才能不循环执行当前没有wat的5个 sql_query = """ SELECT DISTINCT DRB_ID FROM ( SELECT DISTINCT DRB_ID, LOT_ID, ROW_NUMBER() OVER (ORDER BY CREATE_TIME ASC) AS RN FROM DRB_INFO_CONFIG WHERE STATUS = 0 ) DRB_CNT WHERE RN <= 5 """ cursor.execute(sql_query) lotresults = cursor.fetchall() logging.info(f"{lotresults}") logging.info("SQL查询5个状态为0的lot任务---结束") except Exception as e: logging.info("查询5个lot并更新状态，数据库操作异常：%s", e) time.sleep(1800) continue with concurrent.futures.ThreadPoolExecutor(max_workers=5) as executor: # 提交所有任务 future_to_lot = { executor.submit(execute_query, test.sql_query, {"DRB_ID": lot_item[0]}): lot_item for lot_item in lotresults } # 处理任务状态（仅关注失败情况） for future in concurrent.futures.as_completed(future_to_lot): lot_item = future_to_lot[future] try: # 显式获取结果以触发可能的异常 future.result() # 结果不保存，仅用于异常检查 except Exception as e: logging.info("任务 %s 失败：%s", lot_item, e) end_time1 = time.time() run_time = end_time1 - start_time1 logging.info("代码运行时间为： %s 秒", run_time) else: with cx_Oracle.connect(user='acme', password='acme', dsn=dsn) as connection: with connection.cursor() as cursor: sql_query = """ update DRB_INFO_CONFIG set status = :1, REPORT_STATUS = :2, ACE_LAST_UPDATE_TIME = SYSDATE where REGEXP_LIKE(LOT_ID, '^[BC]0') and status='0' """ cursor.execute(sql_query, (1, 9)) logging.info("fail开关打开") connection.commit() 为这段代码建立定时任务