How do i configure a SQL job or SSIS package to fire/ run in different timings defined in a column in table.
Core Problem:
I have a table with a notification system, where note appearance is dependant on status(is it read / Updated / Closed / delay in any of those statuses). I need a job/SSIS to trigger every 10 minutes when isOpened Flag = 0. when isOpened = 1 and isUpdated = 0 run job/SSIS every 15 minutes after 30 minutes from turning isOpened to 1.
Found the desired answer online on the below URL:
https://www.mssqltips.com/sqlservertip/3052/simple-way-to-create-a-sql-server-job-using-tsql/