2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Scheduler  allows you to add a process to a job scheduler (also referred to as a “cron”) so that database synchronizations can occur automatically (as per your scheduled time).“Cron Settings” refer to the time that you are going to set for the process to perform the synchronization.

The Scheduler page, can be accessed within a project from the left navigation and the below screen shot illustrates the scheduler process.

To operate the scheduler, please refer to the following instructions and reference the following tables. The tables provide a description and example of each field. The window on the application entitled “Cron Help” also contains useful information regarding what data is acceptable to input into the “Cron Settings”
1. Select the profile that you want to from the drop-down list and set process and the Cron settings for the profile.
2. Click on the “Save Cron Job” button to save the page settings.

Table of fields for “Add Scheduled Cron” section of the application page:

Field Name

Description

Example

Profile

Select the profile name from the drop down list.
Note: Profiles have to be created first on the profiles page before they will appear in this drop down list

SalesforceDatabaseBiDirectional

Process

Select the process from the drop down list.
Note: Profiles have to be created first on the profiles page before they will appear in this drop down list

 

Table of Cron Settings

Field Name

Description

Example

Cron Settings

Allows you to set the profile cron settings in the database.

 

Seconds

Enter the “seconds” value Note: Allowed Values:0-59 Allowed Special characters: , - * /

0

Minute

Enter the “minute” value Note: Allowed Values:0-59 Allowed Special characters: , - * /

2

Hour

Enter the “hour” value
Note: Allowed Values:0-23 Allowed Special characters: , - * /

1

Day of Month

Enter the “day” of month value
(please see “Cron Help” on the scheduler page in the application for more information)
Note: Allowed Values:1-31 Allowed Special characters: , - * ? / L W

2

Month

Enter the “month” value
Note: Allowed Values:1-12 or Jan-Dec Allowed Special characters: , - * /

Nov

Day of the week

Enter the day of week value
Note: Allowed Values:0-7 Allowed Special characters: , - * ? / L #

3

(info) Notes regarding the Scheduler:
1. Support for specifying both a day-of-week and a day-of-month value is not complete (you'll need to use the '?' character in one of these fields).

2. Overflowing ranges is supported - that is, having a larger number on the left hand side than the right. You might do 22-2 to catch 10 o'clock at night until 2 o'clock in the morning, or you might have NOV-FEB. It is very important to note that overuse of overflowing ranges creates ranges that don't make sense and no effort has been made to determine which interpretation CronExpression chooses. An example would be "0 0 14-6? * FRI-MON".

Panel
Create, Edit, Delete Schedule

To create a schedule job , one have to follow the below guidelines. 

  1. For creating a schedule job, user has to select the process for which he wishes to create the schedule, Select the date range and repeat factor and hit the save button.
  2. The record saved will be displayed as the top record in the schedule table as shown in the screen shot.
  3. The Repeat factor is usually of two types one is No Repeat where a single job is created , executed and purged and if any time interval is selected the job created will repeat for the chosen time intervals 
  4. To Edit a schedule job, user has to press the Edit button from the schedule table and make the changes from the form and in case of edition Save As button will be enabled so that new record will be created , if user hits save button the same record will be over written.
  5. To Delete a schedule job, the user has to press the Delete button the schedule table so that the record will be purged from the database and no future schedules are run.

The Below table explains the schedule elements of the schedule .

S.No

Element Name

Element Description

Possible values

1

Start Date

The date on which job should be triggered

DD-MM-YYYY

2

End Date

The date on which job should end in case of repeat

DD-MM-YYYY

3

Hours

Hour is the time component

0-23

4

Minutes

Minutes are the time component

0-59

5

Days of Month

possible day of the month

1-31

6

Month

possible months with in a year

1-12

Panel

(info) Scheduler is not supported for QuickBooks Desktop Integration as QuickBooks WebConnector is used to schedule data transfers