Auto Scheduler

Cory Fifield -

 

Auto Scheduler

The Auto Schedule feature allows you to schedule your VDM Views to run unattended.  To create a new or modify an existing Auto Scheduled VDM view, click on the Auto Schedule button on the Ribbon Bar.

 

Creating a New Auto Schedule

1. Click the  next to VDM File Name to browse to your VDM View

2. Click the  next to Export Location to browse out to your desired output location

    • The export file name will be the name of the VDM Auto Schedule job (.vdmas) with the Export Selection control name and the Export Data Format file extension.

3. Select the export Data Format.



4. Enter the Date/Time you wish to execute the Auto Scheduler and click the  to add

  • Multiple schedules can be added (Please be careful not to overlap your selected times)



5. Select whether you’d like to export the Details, Summary, Chart or Gauge.



6. Overwrite Existing

  • Checked: VDM will replace the output file if it already exists.
  • Unchecked: exported with the date and time stamp added to the file name.

7. Excel Password

  • If you choose Excel as your export type you have the option of adding a password.

8. Click the  icon to Save the view.

9. Separate Session is primarily used if there is a job in the queue that may take longer than others. This option will ask VDM to launch a separate VDM session, login to your database and run the View in parallel to the rest of the queue.

10. The Database tab tells VDM what database the Auto Scheduler job should use for the selected View.



11. The Parameters tab allows you to define the values for any Filter Parameters that may be included in the selected VDM View.

 

Adding a Parameter in The Auto Scheduler

  1. Click on the parameters tab and fill in the appropriate parameters you would like to use in the scheduled view.

 

Quick Tip: You can repeat this process multiple times using the same view with different parameters. Be sure to save each auto schedule job with a different name.

Email/FTP

Required information to send email.

Check with your email provider or email administrator for the following settings.

  • Mail Server - The Name or IP address of your email server.  
  • Port - Port used for sending email.
  • Username - Username for the account sending email.
  • Password - Password for the account sending email.
  • To - The recipient of the email (only used for job success or failure notifications)
  • From - The email address associated with the account sending email.

Click here for common e-mail provider settings. 

 

**The following example is setup using Hotmail**

 

 **The following example is setup using an email profile**

 

Using the Auto Scheduler with Multiple Database Connections

To run the Auto Scheduler on multiple databases it requires the database connection information for a given Auto Scheduler Job. The database connection information is defined on the Database tab on the Auto Scheduler Setup form.

 

Modify Existing Auto Schedule

To modify an existing Auto Schedule, click the Open button on the Ribbon Bar. Select your Auto Scheduler file (.vdmas) and click Open.

Make any needed adjustments and Save the updates by clicking on the Save button on the Ribbon Bar. You can also delete a schedule by clicking on the Delete button on the Ribbon Bar.

 

Starting the Auto Scheduler

To start the Auto Scheduler, click on the Enable Scheduler icon. While the Auto Scheduler is enabled you cannot continue to use VDM as it will interfere with the Auto Scheduler process.  We suggest that VDM be minimized.  Please note VDM must remain running on the workstation for the Auto Scheduler to function and any Windows Power Saver options on the computer should be disabled.

To turn off the Auto Scheduler, click on the Enable Auto Scheduler button on the Ribbon Bar.

Once you start the Auto Scheduler it will list the jobs set to run and the times they’re scheduled to run.

Have more questions? Submit a request

Comments

Powered by Zendesk