目的
次のURLとメソッドを使用してジョブを編集します。
アイテム | 説明 | ||
---|---|---|---|
URL | /datamover/jobs/job-name | ||
メソッド | PUT |
リクエストのパラメータ
- uowid
- 説明: 作業単位ID
- sourceLogin
- 説明: ソース システムのプロパティ
- targetLogin
- 説明: ターゲット システムのプロパティ
- settings
- 説明: ジョブ構成プロパティ
- jobSecurity
- 説明: ジョブのセキュリティの詳細
- objects
- 説明: コピーするオブジェクト
応答のパラメータ
応答のパラメータは必要ありません。
応答の例
{ "message" : "Job definition not found: failed-multi-table" }
edit RESTful APIの例(TeradataからTeradataへ)
{ "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", "forceTargetStagingTable": "true", "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" } ], "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" } ], "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" } ] } ] }