3.4 Set up a Scheduled Job


Setting up a Scheduled Job allows for Data Synchronization to occur at a set time, allowing for data to be updated automatically in Salesforce from SAP (or other system). 

 

1. Navigate to the Scheduled Jobs tab (1). Select New Scheduled Job (2).

 

 

2. Enter a Job Name (1), Frequency (2) and choose your Salesforce Job connection String for the Connection String (3), which will allow Overcast to access your Salesforce org at scheduled times. Go to Connection String for Salesforce for more information.
Select your Start Date (4) and the time of day you wish the job to run in the Hours (5) and Minute (6) fields . If you need to limit how long you would like the job to run, you can enter an End date (7). In this example, we chose a "Weekly" Frequency, in off-peak hours at 1:00 a.m. 

 

3. Scroll Down to the Frequency Section. As "Weekly" Frequency has been chosen, select the day of the week (1). You can ignore the Frequency: Monthly (2) section since you've selected this to run each week. Select Save (3).

If you choose a Frequency of "Monthly" above in step 2 (2), you would ignore the Frequency: Weekly section (1), and instead populate the Frequency: Monthly (2) section.

 


Create a Schedule Task

A Schedule Task associates an Integration Scenario with the Scheduled Job.

 

1. Now that the Scheduled Job is created, scroll to the Schedule Tasks section. Select New Schedule Task.

 

2.  Enter a Task Name for the Schedule Task (1). The Description field is optional. Note that your Schedule Job is already populated and it is marked Active. Go to Scenario Setting, select the Data Synchronization Integration Scenario you created under Scenario (2), select "Read" for the Operation field (3), and enter the name of the Query Predicate (for read) or Data Set (for create/update/delete) that you created in the previous unit  into the Scenario Input field (4). Select Save (5).

 

You must enter the Scenario Input name exactly how it is spelled on your Query Predicate Name, located in your Data Synchronization Integration Scenario.



3. The Schedule Job is all set. Click Test Job on the Scheduled Job record to ensure it will work correctly.



4. Schedule this Job needs to be clicked for this job to be active.

 

5. Confirm that the Job Status changes to "Scheduled".

 

6. Scenario "DataSynchronization_Account" will run with Scenario Input "Account Nr. 1001-1500" at 1:00 a.m. weekly on Sunday starting from 7/7/2020 until you select Unschedule This Job.