下载PDF
Enterprise-Level SQL Scheduling at Frontline Technologies
技术
- 基础设施即服务 (IaaS) - 云计算
- 基础设施即服务 (IaaS) - 云数据库
适用行业
- 设备与机械
- 国家安全与国防
适用功能
- 人力资源
- 维护
用例
- 库存管理
- 人员跟踪与监控
服务
- 系统集成
挑战
Frontline Technologies 是劳动力管理软件的市场领导者，其应用程序严重依赖 SQL 数据库。然而，该公司在 SQL 的本机工具方面面临着一些挑战。首先，SQL Server Agent 需要向开发人员和支持人员等用户授予广泛的数据库权限，这是一个安全问题并消耗了大量的员工时间。其次，SQL Server 作业很容易发生阻塞，即一个进程由于消耗系统上其他地方的关键资源而失败。这是在应用程序级别与 SQL 交互时的常见问题。最后，使用本机 SQL 工具进行灾难恢复并没有为 Frontline 提供可接受的同步标准。该公司要求备用生产数据库在发生灾难恢复事件时在 15 到 30 分钟内启动并运行。然而，使用 SQL Scheduler，作业永远不会 100% 同步，并且需要手动复制作业，从而存在丢失最近更改的风险。
关于客户
Frontline Technologies 是一家总部位于宾夕法尼亚州的公司，是劳动力管理软件市场的领导者。该公司通过其三个应用程序为数千名全球客户提供服务：Aesop，一个自动替补安排和缺勤管理系统； Veritime，考勤产品； Jobulator，一种针对代课教师的自动工作通知服务。美国五分之一的学区使用 Aesop 来管理其人员。 Frontline 还扩展到其他各种行业，包括医疗保健、安保人员、现场活动、制造和图书馆。 SQL 作业占公司批处理作业的大部分，但调用 Visual Basic 脚本和 .NET 脚本对于公司的业务也至关重要。
解决方案
Frontline Technologies 在 JAMS Job Scheduler 中找到了一个与他们的需求非常吻合的解决方案。 JAMS 通过接管批处理和调度任务解决了 SQL 相关的安全、阻塞和灾难恢复问题。它集中了用户权限，消除了与授予广泛权限相关的风险。 JAMS 安全性使用 Active Directory 角色在正确的时间以正确的权限级别对用户进行身份验证，从而无需向支持和开发人员授予 SQL 管理权限。 JAMS 作业调度和工作负载自动化独立于 SQL 处理，从而消除了“阻塞”问题。 JAMS 容错架构使 Frontline 可以轻松配置和维护其灾难恢复计划。通过利用 JAMS，Frontline 频繁实施日志传送，确保每 5 分钟备份一次事务和计划更改，并将其发送到辅助数据中心。
运营影响
数量效益
相关案例.
Case Study
Smart Water Filtration Systems
Before working with Ayla Networks, Ozner was already using cloud connectivity to identify and solve water-filtration system malfunctions as well as to monitor filter cartridges for replacements.But, in June 2015, Ozner executives talked with Ayla about how the company might further improve its water systems with IoT technology. They liked what they heard from Ayla, but the executives needed to be sure that Ayla’s Agile IoT Platform provided the security and reliability Ozner required.
Case Study
IoT enabled Fleet Management with MindSphere
In view of growing competition, Gämmerler had a strong need to remain competitive via process optimization, reliability and gentle handling of printed products, even at highest press speeds. In addition, a digitalization initiative also included developing a key differentiation via data-driven services offers.
Case Study
Predictive Maintenance for Industrial Chillers
For global leaders in the industrial chiller manufacturing, reliability of the entire production process is of the utmost importance. Chillers are refrigeration systems that produce ice water to provide cooling for a process or industrial application. One of those leaders sought a way to respond to asset performance issues, even before they occur. The intelligence to guarantee maximum reliability of cooling devices is embedded (pre-alarming). A pre-alarming phase means that the cooling device still works, but symptoms may appear, telling manufacturers that a failure is likely to occur in the near future. Chillers who are not internet connected at that moment, provide little insight in this pre-alarming phase.
Case Study
Premium Appliance Producer Innovates with Internet of Everything
Sub-Zero faced the largest product launch in the company’s history:It wanted to launch 60 new products as scheduled while simultaneously opening a new “greenfield” production facility, yet still adhering to stringent quality requirements and manage issues from new supply-chain partners. A the same time, it wanted to increase staff productivity time and collaboration while reducing travel and costs.
Case Study
Integration of PLC with IoT for Bosch Rexroth
The application arises from the need to monitor and anticipate the problems of one or more machines managed by a PLC. These problems, often resulting from the accumulation over time of small discrepancies, require, when they occur, ex post technical operations maintenance.
Case Study
Robot Saves Money and Time for US Custom Molding Company
Injection Technology (Itech) is a custom molder for a variety of clients that require precision plastic parts for such products as electric meter covers, dental appliance cases and spools. With 95 employees operating 23 molding machines in a 30,000 square foot plant, Itech wanted to reduce man hours and increase efficiency.
