Need help in - Best approach to send email to 100 users reminding them to update SSN of thier depend
We have a requirement where we have to send remider to all employees , to update the SSN of their newly born child . This is a monthly process .
There will be no data send out to employees just a text message to remind them ..
I have thought of few ways to do it , but if there is any better way please suggest..
1) Create a Pl/sql program to identify all such employees who haven't update SSN for thier child and then kick off a workflow to send notification within the program
2) Create a program which will run seprately for each employee and then a shell script which send the output of program as an attachment to each employee