This topic contains the following subtopics:
Each job editor has a Generate Command Line button to launch the Script Generation Wizard, which helps you create batch files that automatically run one or more jobs.
By default, each command line script picks up the name of its job. You can specify output files in CSV, XML, RTF, HTML, or PDF format.
The Report Directory column indicates the location where reports are created.
The Store Results column indicates whether the job results are saved once the job has executed.
Make sure that the job has been saved. |
To create a script file
The changec
command line program runs DB Change Manager job scripts. It is located in the DB Change Manager installation directory.
changec
options include:
-job
option specifies the jobs to run. Its parameter is the fully-qualified job file name and location.-output
option specifies reporting format for the job. Its parameters are: CSV, XML, RTF, HTML, or PDF.-dontstore
flag specifies that the results for the job are not stored.For example, the syntax below runs the MyConfigCompare database comparison job and generates a report in PDF format:
-job
“C:\Users\test1\change_workbench_5_0\workspace\DatabaseChange\MyConfigCompare.dcj”
-output PDF “c:/report”
To execute multiple jobs from the same command line, use the following syntax:
changec -bulk bulk_file_name
Where bulk_file_name
is a file where each row has a -job
option. The -job
option accepts these regular expressions:
For example, the following command runs all jobs in all projects and folders in the workspace:
changec -job workspace:\**\*.caj
To run a job from the command line:
changec -job “path_and_name.dcj” -output report_format “ report_directory_path”
| | | | | | | |