概要
move RESTful APIは、以下のURLとメソッドを使用して指定のジョブを移動します。
| アイテム | 説明 | ||
|---|---|---|---|
| URL | /datamover/executingJobs | ||
| メソッド | POST | ||
リクエストのパラメータ
- jobName
- 説明: ジョブ名
- sync
- 説明: Sync使用の仕様 syncがfalse(デフォルト)の場合、startコマンドはジョブ実行名が生成されたときのステータスを返します。 syncがtrueの場合、startコマンドはジョブが完了するとステータスを返します。
- uowid
- 説明: 作業単位ID
- saveChanges
- 説明: 指定されたパラメータで元のジョブ定義を更新します
- sourceLogin
- 説明: ソース システムのプロパティ
- targetLogin
- 説明: ターゲット システムのプロパティ
- settings
- 説明: ジョブ構成プロパティ
- jobSecurity
- 説明: ジョブのセキュリティの詳細
- objects
- 説明: コピーするオブジェクト
リクエストの例
{
"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",
"stagingToTarget":"DELETE_INSERT"
},
{
"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"
}
]
}
]
}