Before working with tutorials, identify two data sources that you can use for practice. These data sources should not be live or mission-critical, and they should be similar in schema and data.
When you need to repeatedly run the same job, you can set up automated tasks that execute the jobs on a regular schedule. DB Change Manager helps create a command line executable for any job. You can run the command line executable on an ad hoc basis. You can also group the commands into a batch file and run them.
To define command line syntax and generate batch files
- Open the job for which you want to define an execution script.
- Select the Command Line Syntax icon in the upper right of any tab.
- In the Script Generation Wizard, add output report options.
- Specify the Directory where the files are generated.
- Click Next.
- Specify the Location where the batch file is generated.
- Specify the file format for the script.
- Click Finish.
DB Change Manager generates the file and saves it to the location you specified.
If you want to add multiple jobs to the batch file, generate a batch file as normal, and then copy the script syntax to the clipboard for each job you want to add to the batch file. You can then add them to the existing batch file manually.