Create hooks for specific site

Hello community,

I want to make a scheduled task that runs every hour for specific site. I have put my function name in hooks.py and added a check for frappe.local.site but it won’t run.
The function works when I execute it manually using bench --site my-site execute path.to.my.function or bench --site my-site trigger-scheduler-event hourly.

Thank you