scheduler, file transmissions, & additional tools

Scheduler, File Transmissions, & Additional Tools

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

Scheduler Setup – Installation File• Installing the service• Run setup file, follow prompts, finish installation

Scheduler Setup – CONFIG File• Verify the connection string settings in the CONFIG file

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

Scheduler Setup – Windows Service• Ensure service is set to start / run automatically

Scheduler Setup – eoStar Plugin• Update License Information from Rutherford Tech Link• Upgrade DB to include scheduler options

Mail Delivery Method – DB Mail

Mail Delivery Method - SMTP

Scheduler – General Usage• ION Reports

Scheduler – General Usage• SQL Reports

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

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

Maintenance Tools – Configuration Screen• Interface to schedule tasks Demo

Bonus – Scheduler Testing Tool

• On-Demand processing of scheduled tasks

Discuss | Ask | Suggest

•Tom Veen•tomv@eostar.com

•Chris VanRandwyk•chrisv@eostar.com