I searched on this and didn't run into anything so if someone could point me in the right direction I would appreciate it.

I want to run an update every night just after midnight (server time) to update the status of records in a table that are expired based on an expired date carried in the table. I can write the syntax of the query just fine but I don't know how to make it fire on a schedule.

Thanks