New Subjob Dialog

General setup > Subjobs > Add a subjob

What is the dialog used for?

To create a new subjob.
A subjob specifies the unit of data to replicate. Subjobs can only be run within the context of a job that defines the source and destination locations for the data. Subjobs are, however, independent of jobs in the sense that they can exist on their own without being actually used by a job. In that sense, a subjob can be on the subjob list of zero, one or more jobs.

Fields & buttons	Description
Description	Enter a description for the new subjob
Replication method	Select one of the three types of replication methods: Normal - The contents of a database table are replicated as a whole. Normal subjobs are suitable for small tables or cases where entire tables must be replicated like when preloading a new store or a POS. Normal subjobs also support replication counters, where a unique index exists that can be used to select records to be replicated. This is useful when replicating transactions from POS, so only the newest records will be replicated. Action - The contents of a database table are replicated by reading a second table, the action table. The action table determines which rows in the main database table have changed and how. Action subjobs are suitable for large tables when you want to minimize data flow by replicating only the changes made in the source location. Stored Procedure - An action table is read on the source location and for each suitable entry in the action table, a stored procedure is run on the destination locations. Stored procedure subjobs are suitable for replicating business logic transactions implemented through stored procedures.
Copy from	Select an existing subjob to copy all settings from. This will override the replication method selection.

Fields & buttons

Description

Enter a description for the new subjob

Replication method

Select one of the three types of replication methods:

Normal - The contents of a database table are replicated as a whole. Normal subjobs are suitable for small tables or cases where entire tables must be replicated like when preloading a new store or a POS. Normal subjobs also support replication counters, where a unique index exists that can be used to select records to be replicated. This is useful when replicating transactions from POS, so only the newest records will be replicated.
Action - The contents of a database table are replicated by reading a second table, the action table. The action table determines which rows in the main database table have changed and how. Action subjobs are suitable for large tables when you want to minimize data flow by replicating only the changes made in the source location.
Stored Procedure - An action table is read on the source location and for each suitable entry in the action table, a stored procedure is run on the destination locations. Stored procedure subjobs are suitable for replicating business logic transactions implemented through stored procedures.

Copy from

Select an existing subjob to copy all settings from. This will override the replication method selection.

Last updated:	12th May 2013
Version:	LS One 2013.1