Dokumentation zu: TcExtractData_2013_10 (C) J.Feuerstein
Erstellt: 09/2013   J.Fes
Stand   : 01.10.2013    J.Fes

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: Aktion: Extraction von TC Daten

CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action "TcExtractData_2013_10"
                       -SubAction  "DS_of_IR"

Examples:
: 19.09.2013/A.Becker
-Action "TcExtractData_2013_10" 
-SubAction "DS_of_IR"
-JobRoot_DP "C:\tmp"
-TnsNames_dpne "V:\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer.Custom\TnsAdmin\tnsnames.ora"
-DbNetworkAlias "tc83"
-u "infodba" 
-p "infodba"
-SqlScript_dpne "V:\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer\Resources\TCSQL_TEST\IR_Datasets_NamedRef_Attr.SQL"
-Obj_ReleaseState_dpne "D:\addPLM\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer\Resources\TCSQL_TEST\Obj_ReleaseState.sql"
-OraClient_dp "V:\JobManager\ProgEntw\Ver02\JobManagerV2\03-BinPublic\OraClient"
-ResultFile_dpne "#JobRoot_DP#\TcExtractedData.xml"

-Action "TcExtractData_2013_10" -SubAction "DS_of_IR" -JobRoot_DP "C:\tmp" -TnsNames_DPNE "V:\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer.Custom\TnsAdmin\tnsnames.ora" -DbNetworkAlias "tc83" -u "infodba" -p "infodba" -SqlScript_DPNE "V:\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer\Resources\TCSQL_TEST\IR_Datasets_NamedRef_Attr.SQL" -Obj_ReleaseState_DPNE "V:\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer\Resources\TCSQL_TEST\Obj_ReleaseState.sql" -OraClient_DP "V:\JobManager\ProgEntw\Ver02\JobManagerV2\03-BinPublic\OraClient" -ResultFile_DPNE "#JobRoot_DP#\TcExtractedData.xml"  -verbose -PauseOnEnd


JobManagerCmdTools.exe -Action "TcExtractData_2013_10"
                       -SubAction  "DS_of_IR"

Examples:
: 2.1200;04.11.2013;J.Fes
-Action "TcExtractData_2013_10" 
-SubAction "UsersDefVolCurSubDirFileCount"
-JobRoot_DP "C:\tmp"
-TnsNames_dpne "V:\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer.Custom\TnsAdmin\tnsnames.ora"
-DbNetworkAlias "tc83"
-u "infodba" 
-p "infodba"
-SqlScript_dpne "V:\JobManager\ProgEntw\Ver02\JobManagerV2\03-BinPublic.ClientServer\JobManagerCmdTools_Resources\TcExtractData_2013_10\SubAction_UsersDefVolumeCurSubDir.sql"
-para_like_PUSER_ID "%"
-OraClient_dp "V:\JobManager\ProgEntw\Ver02\JobManagerV2\03-BinPublic\OraClient"
-ResultFile_dpne "#JobRoot_DP#\TcExtractedData.xml"
-RevokeGrand_RunIfMoreThenMaxFilesInDir "15" 
-RevokeGrand_Cmd_DPNE "C:\tmp\RevokeGrand.cmd"
-MsgLog_DPNE "C:\tmp\RevokeGrand_JCMSG_Log.txt"

New: 2.1200;04.11.2013;J.Fes
-Action "TcExtractData_2013_10" -SubAction "UsersDefVolCurSubDirFileCount" -JobRoot_DP "C:\tmp" -TnsNames_dpne "V:\JobManager\ProgEntw\Ver02\JobManagerV2\01-BinServer.Custom\TnsAdmin\tnsnames.ora" -DbNetworkAlias "tc83" -u "infodba" -p "infodba" -SqlScript_dpne "V:\JobManager\ProgEntw\Ver02\JobManagerV2\03-BinPublic.ClientServer\JobManagerCmdTools_Resources\TcExtractData_2013_10\SubAction_UsersDefVolumeCurSubDir.sql" -para_like_PUSER_ID "%" -OraClient_dp "V:\JobManager\ProgEntw\Ver02\JobManagerV2\03-BinPublic\OraClient" -RevokeGrand_RunIfMoreThenMaxFilesInDir "15" -RevokeGrand_Cmd_DPNE "C:\tmp\RevokeGrand.cmd" -verbose -pauseOnEnd -MsgLog_DPNE "C:\tmp\RevokeGrand_JCMSG_Log.txt"


--------------------------------------------------------------------------------------------------------------------------------------------------------------------

JobManagerCmdTools.exe 
-Action "TcExtractData_2013_10"
-SubAction  "CompareTCExtractedData"
-JobRoot_DP "C:\tmp"
-ResultFile1_dpne
-ResultFile2_dpne

Examples:
#Doc: 08.11.2013 S.Güth
-Action "TcExtractData_2013_10" -SubAction  "CompareTCExtractedData" -JobRoot_DP "V:\CustomersDataL\addPLM\2013-11-08\tceng_GenericExample_00173_CustomerNameShort" -ResultFile1_dpne V:\CustomersDataL\addPLM\2013-11-08\tceng_GenericExample_00173_CustomerNameShort\result1.xml -ResultFile2_dpne V:\CustomersDataL\addPLM\2013-11-08\tceng_GenericExample_00173_CustomerNameShort\result2.xml
