Creating Multiple Scheduler Jobs Using Bulk Creation

This article explains how to use Bulk Creation in the VDM Scheduler to create multiple Job executions from data stored in a delimited file.

Each row in the source file represents a Job execution and can provide values such as database information, export locations, filenames, and email recipients.

Prerequisites

Before using Bulk Creation, make sure you have:

• VDM installed and accessible.
• Permission to create Database Files, Views, and Scheduler Jobs.
• A valid database connection profile.
• A CSV or other delimited file containing the information required for the Jobs.
• Read access to the source file location.
• Write access to any export locations used by the Jobs.
• Access to the VDM Scheduler.

Prepare the bulk-creation data file

Create a CSV or other delimited file containing one row for each Job execution you want to create.

Columns can contain information such as:

• Database name
• Customer or client information
• Export location
• Export filename
• Email recipients
• Other values required by the Job

Important: Include all values required by the Bulk Creation configuration. If required information is missing, some options may not be available when creating the Jobs.

Import the delimited file into VDM

Add the text file

In the Tables and Fields panel:

1. Right-click Database Files.
2. Select Add From Text File.
3. Select Delimited.

Configure the file options

Configure the settings for the source file.

File Options

• File — Browse to the delimited file.

  Example:

  C:\Temp\BulkImport.csv

• File Selection — Select Single when importing one file.
• Fields Enclosed in Quotes — Set to True if values are enclosed in quotation marks.

• Delimiter — Enter the character used to separate fields.

  Example for a CSV file:

  ,

• Include Headers — Set to True if the first row contains column names.

Table Options

• Add Import Date — Adds the import date to the imported data.
• Add File Name — Adds the source filename to the imported data.

• Name — Enter a name for the Database File.

  Example:

  BulkJobs

Search Options

• Refresh on View Search — When set to True, VDM refreshes the Database File from the source file before the View search runs.

Finish the import

1. Select Preview and review the imported data.
2. Adjust column data types if needed.
3. Select Test Import.
4. Confirm that the import completes successfully.
5. Select Finish.

The imported file appears under Database Files in VDM.

Create and verify the View

The Bulk Creation process uses a VDM View to provide the values used to create the Job executions.

Add the Database File to a View

1. Create a new View or open an existing View.
2. Locate the imported file under Database Files.
3. Add the Database File to the View.

Run the View

Select Run View.

Review the Detail Grid and verify that:

• All expected rows are present.
• Column names are correct.
• Data values are correct.
• Dates, numbers, and text use the expected data types.

Save the View after confirming the results.

Open Bulk Creation in Scheduler

1. Open Scheduler.
2. Select Jobs.
3. Create or open the Job that will use Bulk Creation.

Add the View

1. In the Job setup, locate the View section.
2. Select Add.
3. Select the View created from the bulk-creation data file.

The selected View supplies the rows and values used during Bulk Creation.

Start Bulk Creation

In the Executions section, select Bulk Creation.

The Create Job Wizard opens.

VDM uses the selected View to create multiple executions based on the rows returned by the View.

Configure the Job executions

Execution Name

Enter or select the value that will be used to identify each execution.

Examples:

Daily_Import_Job

Customer_Data_Export

Connection Profile

Select the connection profile used by the generated executions.

Important: Make sure the source View contains the information required by the Job configuration, including database information and any other values referenced during Bulk Creation.

Configure export options

If the generated Jobs export Detail Grid results, configure the required export settings.

Export Location

Specify the folder where the exported file will be saved.

Example:

C:\Exports\

Export Filename

Specify the filename or select the field that provides the filename.

Examples:

CustomerData

SalesReport

Date Format

Select the date format to append to the filename when required.

Examples:

YYYYMMDD

MMDDYYYY

File Type

Select the required output format, such as:

• CSV
• Excel

Finish Bulk Creation

Complete the Create Job Wizard.

The generated executions appear in the Job's Executions section.

Each generated execution represents a row returned by the View and uses the values configured through Bulk Creation.

Edit an individual execution

After Bulk Creation is complete, individual executions can be edited if needed.

Select an execution and update settings such as:

• Export location
• Filename
• Connection profile
• Other execution-specific settings

Save the Job after making changes.

Verify the bulk-created executions

After Bulk Creation:

1. Review the generated executions.
2. Confirm the expected number of executions were created.
3. Verify the values assigned to each execution.
4. Run a test execution if needed.
5. Confirm that the expected output is created successfully.
6. Save the Job.

Related articles

• Scheduling Jobs Using the VDM Scheduler
• VDM Scheduler Setup and Configuration Guide
• Using Dynamic Date Values in the Job Execution Wizard