I am managing a table that stores various job entries for employees. Each job entry includes a column for duration. I would like to trigger an alert or other event when the duration of a job has ended. My project is built using Laravel and VueJS. Below is an example of a job entry in the table:
id: 3
job_name: Rep 01
job_description: ASA
start_date: 2022-10-12 10:39:00
end_date: 2022-10-14 10:39:00
duration: 01:00
client_name: Katell Rollins
client_phone_number: +1 (401) 558-7758
client_address: ----
job_completed: 0
created_at: 2022-10-12 08:39:21
updated_at: 2022-10-12 08:39:21