loan reminder

Question

im working i insurance project i got a problem in reminder section in in this project there is differant type of loan if any lone is expire we got a reminder before 1 week. please help me. thank you..

Pradip Pandey · Answer

For this create a stored procedure to get the list of expired loan. Then create a job and call the procedure in it. Schedule & run your job. Hope it will help.