Contents

Schedule data generation

You can use any third-party scheduler tool, for example, Windows Task Scheduler to create and manage data generation tasks that your computer will carry out automatically at the times you specify.

Scheduling data generation includes the following steps:

• Create a .bat file with the Data Generator tool
• Create a data generation task using Windows Task Scheduler

Create a .bat file with the Data Generator tool

1. On the Tools menu, click New Data Generation. The Data Generator Project Properties wizard opens.

2. On the Connection page, specify the connection, select the required database, and click Next.

3. On the Options page, set the data generation options and then click Open.

4. On the Tables and columns to populate pane, select the tables and columns to populate and click Populate the data to the target database.

5. In the Data Population Wizard that opens, set the data population options and then click Save Command Line.

6. In the Command line execution file settings window that opens, specify a project file that stores a data generation template,verify, and configure the settings to manage the *.bat file text.

Command-line file settings

Name	Default State	Description
Project File	No	Specify a data generation template to use.
Connection	Yes	Specify the connection string.
Password	No	Specify the connection password. It overrides the password specified in the connection string.
Error Mode	No	Specify the application behavior when an error is occurred. To ignore all errors during the data population, specify: ignore. To cancel the data population if any error occurs, specify: abort.
Treat Warning As Error	No	When enabled, it treats all warnings as errors. Further behavior is determined by the errormode option. When disabled, it does not treat all warnings as errors and executes with warning messages.
Echo OFF	No	When enabled, all the text in the.bat file will be enclosed in the @Echo OFF … @Echo ON construct. This will disable the display of the commands being entered on the screen.
Keep opened	No	When enabled, the pause command will be placed at the end of the .bat file text. This will leave the command window open.
PowerShell	No	When enabled, the & symbol will be generated at the beginning of the .bat file text. This will ensure PowerShell compatibility.

Create a data generation task using Windows Task Scheduler

1. Open Task Scheduler and navigate to the Actions pane and click Create Basic Task to create a scheduled task.

2. In the Create Basic Task Wizard window that opens, specify the name and description of the task and click Next.

3. On the Trigger page, choose when to launch the task and then click Next.

• Schedule based on the calendar: Daily, Weekly, Monthly, or One time. For this, specify the schedule you want to use.
• Schedule based on common recurring events: When the computer starts or When I log on.
• Schedule based on specific events: When a specific event is logged. For this, specify the event log, source, and even ID using the drop-down lists.

4. On the Action page, click Start a program to schedule a program to start automatically and then click Next.

5. On the Start a Program subpage, click Browse to select the .bat file you have created in the Data Generator Properties wizard and then click Next.

There are optional fields that you can set:

• Add arguments: Specify the arguments to run the task with specific instructions.
• Start in: Specify the folder in which the program will start.

6. On the Finish subpage, verify the settings and click Finish.

The task will be displayed in the Active Tasks section.

Want to Find out More?

• Previous
• Next