CopyStormJob 2018-03-15T15:26:26+00:00

CopyStormJob

The CopyStormJob table is the root descriptor for all tasks associated with a single Salesforce instance. It contains login credentials for a Salesforce instance and its corresponding CopyStorm backup database.

Note that both Salesforce and CopyStorm backup credentials are optional and will override any credentials specified in the corresponding CopyStorm configuration file. However, credentials stored in this table are useful when a common CopyStorm configuration file needs to be used for many different Salesforce and CopyStorm databases.

CopyStormDirector also defines a view, CopyStormJobView, which combines information in the CopyStormJob table with the most recently executed task (and its status).

The following table describes each field in the CopyStormJob table:

Column Name Data Type Required Description
id integer Yes Unique identifier assigned to the job by CopyStorm/Director. This value may be used to refer to the job using the CopyStorm/JobRunner application.
name varchar Yes Unique, human-readable name assigned by a user to this job.
sfInstanceType varchar Yes Indicates whether the target Salesforce is a Production, Sandbox, or DatabaseDotCom instance.
sfUsername varchar No An optional username that will be used to login to Salesforce.
sfPassword varchar No An optional password that will be used to login to Salesforce.
sfLoginHost varchar No Used to override the Salesforce host used to process login requests.
dbType varchar Yes The target CopyStorm database type.
dbUsername varchar No An optional username that will be used to login to the CopyStorm database.
dbPassword varchar No An optional password that will be used to login to the CopyStorm database.
dbConnectionString varchar No An optional JDBC connection string that will be used to connect to the CopyStorm database.
active char Yes Indicates if tasks defined for the job should be considered for execution. Possible values are “Y” and “N”.
deleted char Yes Indicates if the user has deleted the job from CopyStorm/Director. Possible values are “Y” and “N”. Jobs in this state can be undeleted.
description varchar No A block of text describing the purpose of the job.
createdDate datetime Yes The date on which the job was created.
lastModifiedDate datetime Yes The date on which the job was last modified.

CONTACTS

Product Questions: info@capstorm.com
Technical Support: support@capstorm.com
Phone: +1 314.403.2143