In order to make an alert for "Ending Probation Period" I have created a periodic Alert, this alert will check daily if there is any employee already near to 80 days from hire date to sysdate it will send an e-mail alert to us... using the below query in the alert .... the query is verified and can run but no e-mails received
anybody can help ....
where sysdate BETWEEN effective_start_date and effective_end_date
and sysdate - original_date_of_hire < 85
and sysdate - original_date_of_hire > 80