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: Sync 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
- jobSecurity
- Description: Job security details
- objects
- Description: Objects to be copied
Request 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": "DSA", "dataStreams": 5, "sourceSessions": 10, "targetSessions": 10, "onlineArchive": "false" } }, "jobSecurity": { "ownerName": "user10", "readPermission": { "users" : [ "user1", "user2", "user3" ], "roles" : [ "role1", "role2", "role3" ] }, "writePermission": { "users" : [ "user1", "user2", "user3" ], "roles" : [ ] }, "executePermission": { "users" : [ "user1", "user3" ], "roles" : [ "role1"] } }, "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", "forceTargetStagingTable": "true", "selection": "included", "exportWithoutSpool": "false" }, { "name": "srcTableB", "compareDDL": "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", "forceTargetStagingTable": "true", "selection": "included", "copyData": "false" } ], "foreignServer": [ { "name": "foreignServer1", "selection": "included" }, { "name": "foreignServer2", "selection": "included" } ], "functionAliases": [ { "name": "faObj", "database": "dmguest", "selection": "included" }, { "name": "FAObjForForeignSer", "database": "myDb", "selection": "included" } ] "indices": [ { "name": "OrdersHI", "indexDatabase": "indexDB", "indexType": "hash_index", "selection": "included" }, { "name": "sji", "indexDatabase": "indexDB", "indexType": "join_index",as "copyStats": true, "selection": "included" } ], "schema": [ { "name": "avroRecordSchema", "compareDDL": true, "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" } ] } ] }