如何每小时更新第二个表中一个表的值？

from apscheduler.schedulers.blocking import BlockingScheduler
import pymysql

def update_table():
    # 连接数据库
    conn = pymysql.connect(host='localhost', user='username', password='password', database='database')
    cursor = conn.cursor()
    
    try:
        # 执行更新操作
        sql = "UPDATE table2 SET value = 'new_value' WHERE id = 1"
        cursor.execute(sql)
        conn.commit()
        print("更新成功")
    except Exception as e:
        conn.rollback()
        print("更新失败:", str(e))
    finally:
        # 关闭数据库连接
        cursor.close()
        conn.close()

# 创建定时任务
scheduler = BlockingScheduler()
scheduler.add_job(update_table, 'interval', hours=1)

# 启动定时任务
scheduler.start()