Launchpad Scheduler - User Guide
Launchpad Scheduler Guide
In this guide the steps for creating a Basic Scheduled Report job as well as advanced Configuration
Creating a New Scheduled Job
Click on the New Job icon
Task
Give the Task Description a Name
Click Save
Schedule
Click on Schedule to Create or Modify the Schedule for the report
Select the Triggers Tab and click on New to create or Select existing schedule to Modify
Set the parameters for the Schedule then click OK
Here we are defining a Weekly Schedule
Report
Set the Connection Key and Select the Report you would like to schedule
Export Options
Select the Export Option (PDF is default)
Set the Path to a working directory and filename
Select the checkbox for Temporary file if required
Select the checkbox for Temporary file if required
Make sure that the File Path Directory has the Web Servers IIS_USER permissions for read/write/execute
Email
Fill in the Email addresses for the recipients, Subject, and Body
*Note the From address should have send as permissions for the svc account used
Additional Attachments
Here you can select additional attachments for the Email
Advanced
Variables
In scheduler you will notice Check boxes across various fields
Any column that is Checked will be analyzed for a variable
Variables are defined by the Query under Advanced Configuration
Any column that is Checked will be analyzed for a variable
Variables are defined by the Query under Advanced Configuration
If using a query for a report, you would set this on the Task tab
under Configuration ID select your query form the drop down
under Configuration ID select your query form the drop down
Advanced Configuration
Define the SQL Query to be used for a report that accepts parameters
The return of the query can be used as a variable
Column Substitution occurs for each record returned
Column Substitution occurs for each record returned
Variables here are defined as {0},{1},{2}
{0} = PurchaseOrderID
{0} = PurchaseOrderID
{1} = Vendor Email Address
{2} = Buyer
Database Commands
Pre Process runs before the Job starts
Current process runs for each result in the job
Post Process runs when the entire job ends
Current process runs for each result in the job
Post Process runs when the entire job ends
You can set Variables here as well
Example: The SQL Action Query is executed​ Updating the PO Printed Flag
The check box is flagged and variable {0} used in the query to accomplish this
Example: The SQL Action Query is executed​ Updating the PO Printed Flag
The check box is flagged and variable {0} used in the query to accomplish this
Related Articles
Launchpad - Release Notes
version: 1100.1001 Date of Release 2025.05.28 Utilizes Crystal Reports x64 now at service pack 37 LaunchPad now has it's own application pool (LaunchPad no longer supports x86) Oracle SQL Server may not work with this Release (to be reviewed at a ...SmartViews Scheduler - Release Notes
version V1000.1200 - CustomAppointmentForm - fix minor issue with parameters showing when there aren't any -ScheduleScreen - Gracefully give user message about concurrency error when appointments that were processed while the UI was open version ...Macro Server - Release Notes
v1100.1001 2025.05.11 (Beta Release) - Add support for editing Visual ERP Macros - VTG.Loader.dll is now using Framework 4.8 - Update supporting nuget packages to latest release. - VTGMACMT.exe has been renamed to MacroEditor.exe v1100.1000 ...SmartViews Scheduler User Guide
PREREQUISITES Supported Visual version are 7.0 – 10.x Database Platform: SQL Server & Oracle Microsoft .Net Framework 4.8 ADMINISTRATION INSTALLING Use the following link to download the setup file. Once downloaded follow these steps to install. Run ...Launchpad Scheduler - Error When Editing Scheduler
Error Caused by Account Settings Id or Password If the Account id/password are not setup correctly the end user could get the following message when trying to add new tasks. To Fix this make sure the account id and password are correct. File->Task ...