Along with User Event, Client, and Mass Update scripts, Scheduled scripts are one of the most used scripts in NetSuite. The benefit of Scheduled scripts is that you can perform actions at a larger scale than some of the other script types, and they can be scheduled to run in the background. So if there is a task that needs to be performed on all transactions created in a day or in a week, a scheduled script can take care of that.

Scheduling Options

Scheduled Scripts can be scheduled as often as every 15 minutes and as distant as every year. I’m not sure of any great need to have a yearly schedule, but you may have some end of the year tasks that you would like to automate and then forget about. Here’s a breakdown of the scheduling options.

  1. One Time: Schedule a script to run at a specific date and time in the future.
  2. Daily: Set up a daily schedule.
  3. Monthly: Set to run a specific day of the month(7th of every month) or on a specific weekday (like the first Sunday of every month).
  4. Yearly: Set the month and the day of the month(or specific weekday in the month).

Repeat: for each schedule a repeat can be set if you need to repeat throughout the day it is scheduled to run. For instance, you could schedule a script to run at 8:00am every Tuesday, and you can set it to repeat every 15 minutes, 30 minutes, 1 hour, 2 hours, 4 hours, 6 hours, 8 hours, or 12 hours.

End By: a scheduled script could be scheduled indefinitely or it could be scheduled to end by a specific date.

Examples

  • Send an email to each person who failed to complete tasks due that day.
  • Update a field on a transaction based on the day’s work done with that transaction.
  • Update custom date fields to assist in tracking things like the number of days on backorder, the length of time spent on each status of a transaction, etc.
  • Automate email reminders to multiple individuals.
  • And so much more can be done with scheduled scripts.

The next Article…

If you have been wanting to get started with NetSuite Development, I hope these overviews have been helpful. In the next article, I am hoping to write an overview of SuiteLet Scripts in NetSuite and all the cool stuff that can be done with them. Stay tuned!

Feel free to leave a comment with your thoughts. If you have any suggestions on future content around NetSuite Development that you would like to see, don’t hesitate shoot me a message or leave a comment.