参考-创建和附加计划求职 [^ ] .

您必须检查结束日期是否已过.如果通过，则更新表中的某些Boolean列，例如"IsActivated".将其更新为0，这意味着它将被停用.

Refer - Create and Attach Schedules to Jobs[^].

You have to check if end date is passed or not. If passed, then update some Boolean column in table something like "IsActivated". Updated this to 0, that means it would be deactivated.