suren (Guest) on Tuesday, February 21 2012, 09:45 AM

can anyone provide the info for running the bods job through command line

can anyone provide the info for running the bods job through command line
       
  •  
    Replied by saurav.mitra on Tuesday, February 21 2012, 04:29 PM · Hide · #1
    The command line utility for SAP BODS is AL_RWJobLauncher.exe located at LINK_DIR/bin
    This utility has limited Command Line input arguments.
    It expects the below arguments:-
    "inet:{JobServer}:{Port_Number}"
    "{Server Log Path}"
    -w (Execute the job and wait for it to complete.)
    -C "Command File Path"

    The command file contains command line arguments to be sent to the engine. You can generate the file for your job using the admin console.

    Go To Management Console.
    Click on the Batch Repository.
    Go to Batch Job Configuration Tab.
    For the interested job select the Action Export Execution Command.
    Enable the options as required.
    Click on Export button.
    Three files will be generated. (Note: Use password file enabled)

    LINK_DIR\log\{Job_Name}.bat which is the executable that can also be scheduled.
    LINK_DIR\log\{Job_Name}.txt which is the engine command file that contains command line arguments to be sent to the engine.
    LINK_DIR\conf\{Repository_Name}.txt which contains the encrypted Password to connect to the Repository.

    Following are the commands we can find in the Command File:-

    -P{Locale} --Locale value

    If we disable Use password file option,
    -S{DB SID} --Database Connection e.g. orcl
    -N{DB Type} --Database Type e.g. Oracle
    -U{RepositoryName} --DB UserName e.g. Scott
    -P;{DB Password} --Encrypted Repository Password for DB User

    Else
    -R"{RepositoryName}.txt" --Password file

    -G"Object Id" --Object Id of JobName.
    -r{1000} --Monitor sample rate/no. of rows
    -T14
    -no_audit --To Disable Enable auditing option
    -no_use_cache_stats --To Disable Use collected statistics option
    -no_dq_capture --To Disable data validation statistics collection
    -Ck --Enable recovery
    -ncollect_cache_stats --Collect statistics for optimization
    -nCollectCacheSize --Use collected statistics
    -xCR --Export Data Quality reports
    -LocaleGV --Locale
    -CSV"$$XYZ=encrypted value;" --Substitution Parameters
    -CtBatch --JobType
    -Cm{HostName} --HostName
    -Ca{Username} --Username
    -Cj{JobServer} --JobServer
    -Cp{PortNumber} --PortNumber
Your Response