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
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
SmartViews Scheduler User Guide
PREREQUISITES Supported Visual version are 7.0 – 10.x Windows Server 2016-2022 Windows 10-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) .NET 4.6.2 ADMINISTRATION INSTALLING Use the following link to ...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 ...Launchpad - Release Notes
version: 1100.1000 Date of Release 2024.11.18 Upgrade to support Visual 11 Oracle SQL Server will not work with this Release (to be done at a later date) January 2024 Updates Visual ERP Application Integration Enhanced (Revision 23129, 22nd January ...SmartViews - User Guide
Prerequisites: Windows Server 2016-2022 Windows 10-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) Visual 7x-10 .NET 4.6.2 if outgoing ports are blocked at the organization’s firewall, the following ...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 ...