I am having a lot of trouble figuring out the right way to get a trigger to work and was hoping to get some suggestions. I have spent more time than I care to admit on trying to figure this out. I ...

Assuming that you will have a table that holds the job details, then the obvious way would be to include a 'Job Expiry Date' column, which will be automatically ...