Overview
The move RESTful API moves the specified job using the following URL and method:
Item | Description | ||
---|---|---|---|
URL | /datamover/executingJobs | ||
Method | POST |
Request Parameters
- jobName
- Description: Job name
- sync
- Description: Synx use specification If sync is false (default), the start command returns status when the job execution name is generated. If sync is true, the start command returns status when the job is complete.
- uowid
- Description: Unit of work ID
- saveChanges
- Description: Update original job definition with specified parameters
- sourceLogin
- Description: Source system properties
- targetLogin
- Description: Target system properties
- settings
- Description: Job configuration properties
- objects
- Description: Objects to be copied
Response Examples
{ "jobName": "tdToTdJob", "sourceLogin": { "teradata": { "tdpid": "sourceSystem", "username": "user", "password": "password", "sessionCharset": "UTF8", "passwordEncrypted": "false" } }, "targetLogin": { "userPool": "poolA" }, "settings": { "priority": "MEDIUM", "overwriteExistingObjects": "true", "freezeJobSteps": "false", "targetDatabase": "targetDatabaseJobLevel", "compareDDL": "true", "logLevel": "99", "tdTdSettings": { "forceUtility": "ARC", "dataStreams": 5, "sourceSessions": 10, "targetSessions": 10, "onlineArchive": "false" } }, "objects": { "database": [ { "name": "sourceDb", "compareDDL": "false", "journaling": "false", "replaceDatabase": "false", "selection": "unselected", "table": [ { "name": "srcTableA", "stagingDatabase": "stagingDBA", "stagingDatabaseForTable": "stagingDBAB", "targetDatabase": "targetDBA", "targetName": "tgtTableA", "validateRowCount": "ALL", "compareDDL": "false", "useExistingTargetTable": "false", "selection": "included", "exportWithoutSpool": "false" }, { "name": "srcTableB", "compareDDL": "true", "useExistingTargetTable": "true", "selection": "included", "exportWithoutSpool": "true", "partialTableParameters": { "sqlWhereClause": "where columnA < 100", "keyColumns": [ "columnA" ] }, "teradataParameters": { "copyStats": "false", "allowTPTLoadMultiset": "true", "journaling": "false", "overrideLockAccess": "false" } } ] } ], "trigger": [ { "database": "databaseA", "subjectTableDatabase": "subjectDatabaseA", "table": "tableA", "name": "triggerA", "actionTime": { "action": "AFTER", "enabled": "NO" }, "selection": "included" }, { "database": "databaseB", "subjectTableDatabase": "subjectDatabaseB", "table": "tableB", "name": "triggerB", "actionTime": { "action": "AFTER", "enabled": "YES" }, "selection": "included" } ], "view": [ { "name": "ViewA", "database": "ViewDatabase", "viewDataTable": { "targetTable": "tableA", "targetDatabase": "dbA" }, "compareDDL": "false", "selection": "included", "copyData": "false" }, { "name": "ViewB", "database": "ViewDatabaseB", "viewDataTable": { "targetTable": "tableA", "targetDatabase": "dbA" }, "compareDDL": "false", "selection": "included", "copyData": "false" } ], "foreignServer": [ { "name": "foreignServer1", "selection": "included" }, { "name": "foreignServer2", "selection": "included" } ], "journal": [ { "name": "journal", "database": "journalDB", "selection": "included" } ], "macro": [ { "name": "macroA", "database": "macroDB", "selection": "included" }, { "name": "macroB", "database": "macroDB", "selection": "included" } ], "storedProcedure": [ { "name": "storedProcedureA", "database": "storedProcedureDB", "selection": "included" }, { "name": "storedProcedureB", "database": "storedProcedureDB", "selection": "included" } ] } }