Scheduler, File Transmissions,

1

• Scheduler, File Transmissions, Additional Tools

2
Topics Covered

• Scheduler
• Setup general use
• Using the scheduler as an alert mechanism
• Transmitting Files
• SRS files
• EDI documents
• Coke Matrix
• Maintenance Tools
• FIFO recompute
• Database Size Reductions

3
Scheduler Setup Installation File

• Installing the service
• Run setup file, follow prompts, finish
  installation

4
Scheduler Setup CONFIG File

• Verify the connection string settings in the
  CONFIG file

5
Scheduler Setup CONFIG File

• Server
• Location of eoStar DB
• Integrated Security
• Windows logon, True / False
• SQL User ID
• SQL Password
• Database
• Name of eoStar DB

6
Scheduler Setup Windows Service

• Ensure service is set to start / run
  automatically

7
Scheduler Setup eoStar Plugin

• Update License Information from Rutherford Tech
  Link
• Upgrade DB to include scheduler options

8
Mail Delivery Method DB Mail
9
Mail Delivery Method - SMTP
10
Scheduler General Usage

• ION Reports

11
Scheduler General Usage

• SQL Reports

12
Scheduler as an Alert Mechanism

• Empty reports do not send
• Create reports to look for missing data
• Missing Ledger Groups
• Missing Tax Area
• No Pricebook Assignment
• No Territory(Can Buy)
• Create reports to look for important information
• Orders with cut items(Driver and OTL)
• Manual priced orders
• Pushed off orders

13
Transmission Maintenance

• FIFO Recompute
• Receive EDI Documents
• Send Coke Matrix exports
• Send SRS exports
• Trim EDI export blobs
• Trim HH Logs
• Trim SRS export blobs

14
Maintenance Tools Configuration Screen

• Interface to schedule tasks Demo

15
Bonus Scheduler Testing Tool

• On-Demand processing of scheduled tasks

16
Discuss Ask Suggest

• Tom Veen
• tomv_at_eostar.com
• Chris VanRandwyk
• chrisv_at_eostar.com