如何使用python自动运行日常SQL脚本(Oracle)？

import cx_Oracle
import datetime

# 数据库连接信息
dsn_tns = cx_Oracle.makedsn('hostname', 'port', service_name='service_name')
conn = cx_Oracle.connect(user='username', password='password', dsn=dsn_tns)

# SQL脚本文件路径
sql_script_path = 'path_to_your_sql_script.sql'

def execute_sql_script(conn, script_path):
    with open(script_path, 'r') as file:
        sql_script = file.read()
    
    cursor = conn.cursor()
    try:
        # 执行SQL脚本
        cursor.execute(sql_script)
        conn.commit()
        print(f"[{datetime.datetime.now()}] SQL script executed successfully.")
    except cx_Oracle.DatabaseError as e:
        print(f"[{datetime.datetime.now()}] Error executing SQL script: {e}")
    finally:
        cursor.close()

# 调用函数执行SQL脚本
execute_sql_script(conn, sql_script_path)

# 关闭数据库连接
conn.close()

0 2 * * * /usr/bin/python3 /path_to_your_script.py