Fortra
Case Studies
Enterprise-Level SQL Scheduling at Frontline Technologies
Overview
Enterprise-Level SQL Scheduling at Frontline TechnologiesFortra |
Infrastructure as a Service (IaaS) - Cloud Computing Infrastructure as a Service (IaaS) - Cloud Databases | |
Equipment & Machinery National Security & Defense | |
Human Resources Maintenance | |
Inventory Management Personnel Tracking & Monitoring | |
System Integration | |
Operational Impact
Moving scheduling and automation off SQL Server with JAMS has ensured that Frontline uses IT resources efficiently. SQL Server, being an expensive tool, is now used for its primary purpose - managing data. This aligns with Online Transaction Processing (OLTP) best practices for keeping application logic off databases. By removing scheduling, Frontline has maximized the useful life from its investments in SQL server licensing. If scheduling had overtaxed database resources, they may have needed to upgrade sooner than every 5-6 years. Furthermore, Frontline has integrated JAMS with internally developed monitoring tools, allowing the company to preemptively identify potential problems. Looking ahead, Frontline sees JAMS as a valuable technology platform. | |
Quantitative Benefit
JAMS backs up every transaction and change to the schedule every 5 minutes, ensuring no data loss. | |
JAMS eliminates the need for manual job copying, saving significant staff time. | |
JAMS allows Frontline to maintain an efficient and secure schedule without granting SQL administrative rights to support and development staff. | |