Hi everyone,
I`m really new in the APEX system, and coding, so i might need more help then it looks.
What i want to do is send an email to someone one month before a especific date set in a column.
What i thought to do is to create a new column with the value: sysdate - Date_in_the_column.
Now what i don t know how to is how to check this to send an email when my new column value is =30. Do i create a job or a process (i need to constatly check this value right, to know when to send the email)? if so how do i do this?
Thank you in advance