Scheduling Map/Reduce Script Submissions in NetSuite

You can schedule map/reduce script deployments for processing in NetSuite. This feature allows for flexibility in running scripts either as a one-time event or on a recurring basis—daily, weekly, monthly, or yearly. Proper scheduling can optimize workflow and ensure timely processing of significant tasks.

How to Schedule a Map/Reduce Script Submission?

To set up a schedule for your map/reduce script, follow these steps:

1. Create Your Script: Upload your JavaScript file to create the map/reduce script entry point. For an initial guide, see related examples.

2. Open the Script Record: Navigate to the appropriate script record and click the Deploy Script button.

3. Check Deployment Status: In the deployment record, ensure the Deployed box is checked.

4. Set Status to Scheduled: Change the Status field to Scheduled.

5. Configure Remaining Fields: Fill out other relevant fields as needed. For detailed field descriptions, refer to the Map/Reduce Script Deployment Record documentation.

6. Set Up the Schedule: On the Schedule Subtab, configure your deployment options. For instance, to submit the script to run every hour:

   • 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

   Note: If the Start Time is set to any time other than 12:00 am, the script will execute at that time, but finish the hourly executions at 12:00 am, resuming only the next day.

7. Save Your Configuration: Finally, click Save to ensure your scheduled task is set.

Important Considerations

• Execution Timing: Keep in mind that the execution times on the Schedule subtab reflect the logged-in user's session time zone, which might differ from the company's set time zone.
• Simultaneous Submissions: If you need to run multiple instances of a script, ensure no prior instance is running. If necessary, create multiple deployments for the script.

Understanding these scheduling options can help you effectively manage and automate tasks within NetSuite, thus improving operational efficiency and time management.

Source: This article is based on Oracle's official NetSuite documentation.

Key Takeaways

• Scheduling allows one-time or recurring map/reduce script submissions.
• Execution time may vary slightly due to system processing.
• Ensure the script is set to deploy to run.
• Be aware of session time zones affecting displayed times.
• For multiple submissions, create distinct script deployments to avoid conflicts.