Send reminder 24 hours before

[harry24]

I want to send reminder 24 hrs before the scheduled date to the user without using flow designer .

This is on custom table which has a field called start date .

[Uncle Rob]

Why not use Flow Designer? 

Anyway, if you don't want to use FD, you can use a business rule to fire gs.eventQueueScheduled and then a script action that runs on that event.

I did a video that does something similar.

[harry24]

can I do this by writing a scheduled job ?? I am looking for some examples for same but no luck

[Uncle Rob]

Scheduled jobs.  Flow designer.  Business rules.
ANYWHERE you can script, you can fire events from.

[Alyza Jannine]

Have you tried Scheduled Script Execution (sysauto_script)? You can schedule it to run periodically and your script should have a computation to determine if start_date is within 24 hours then trigger an event to send the email notification.

Here's a sample script: https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_learnv2_automatingapps_quebec_exercise_create_a_scheduled_script_execution