The following are best practices for scheduled scripts.
Genaral guidelines:
- You should set your scheduled scripts to run during the hours of 2 AM to 6 AM PST. Scripts set to run during the hours of 6 AM to 6 PM PST may not run as quickly due to high database activity.
- The number of Not Scheduled deployments to create should depend on the anticipated number of simultaneous calls you expect to make to this script and the approximate execution time of the script. A general rule of thumb is to create twice as many deployments as the total number of simultaneous calls you anticipate for this script.
- Scheduled deployments and Not Scheduled deployments are executed from the same processor pool. Keep this in mind as you deploy multiple scheduled scripts because the amount pending script instances is the ultimate bottle-neck for scheduled script execution throughput.
- Although there is no restriction on the number of Not Scheduled scripts that can be placed into the processing pool, too many pending scripts may create a backlog and compromise system performance. Because only one script can be run in a processor at a time, you should not overload the system.
- If you want to deploy scheduled scripts that are scheduled to run hourly on a 24 hour basis, the following sample values should be set on the Script Deployment page:
- Deployed = checked
- Daily Event = [radio button enabled]
- Repeat every 1 day
- Start Date = [today’s date]
- Start Time = 12:00 am
- Repeat = every hour
- End By = [blank]
- No End Date = checked
- Status = Scheduled
- Log Level = Error
- Execute as Role = Set to AdministratorIf the Start Time is set to any other time than 12:00 am (for example it is set to 2:00 pm), the script will start at 2:00 pm, but then finish its hourly execution at 12:00 am. It will not resume until the next day at 2:00 pm.
- When possible, schedule your deployments during the hours of 2 AM to 6 AM PST. Deployments scheduled for submission during the hours of 6 AM to 6 PM PST may not run as quickly due to high database activity.
- The number of Not Scheduled deployments to create should depend on the anticipated number of simultaneous calls you expect to make to this script and the approximate execution time of the script. A general rule of thumb is to create twice as many deployments as the total number of simultaneous calls you anticipate for this script.
Deployments that continue to use queues
- If you do not have an account with SuiteCloud Plus, all Scheduled deployments and Not Scheduled deployments that continue to use queues are executed from the same queue. If you deploy multiple scheduled scripts that continue to use queues, your queue size is the ultimate bottle-neck for scheduled script execution throughput. For additional information, see Scheduled Script Deployments that Continue to Use Queues.
- Although there is no restriction on the number of Not Scheduled scripts that can be submitted to SuiteCloud Processors, too many waiting scripts may create a backlog and compromise system performance. Because only one script can be run at a time, you should not overload the system.
- Although there is no restriction on the number of Not Scheduled scripts that can be placed into the processing pool, too many pending scripts may create a backlog and compromise system performance. Because only one script can be run in a processor at a time, you should not overload the system.