IU Health transfers files to vendors and leverages SQLLDR to regularly upload data to databases. The institution needed reliable file transfer capabilities that both used SFTP and that could notify the IT team of job failures.
By migrating to JAMS, IU health has met its file transfer security requirements and streamlined its troubleshooting procedures.
An Australian utility manages its entire load and order process for fuel oil across 23 terminals. More than 25,000 file transfers, JDE jobs, bank transfers, and ESB triggers come together daily to support critical business processes.
Jewelers Mutual provides comprehensive repair and replacement insurance policies for jewelry. The company runs a series of critical jobs against its insurance suite and orchestrates data loads into its analytics platform and data warehouse every night.
A hospitality company had been using SQL Agent and Windows Task Scheduler to move loyalty points between their database and partner networks. The system was difficult to maintain and didn’t provide visibility into the current status of jobs, since the jobs were stored in different systems.
Amedisys’s billing, payroll, and accounting processes required several sequences of jobs to regularly generate invoices, export electronic claims, and export information to journal entries. The jobs were managed by a custom-built scheduler that lacked advanced functionality, and that still required manual processes to complete every step.
Securities America collects daily market data from a variety of sources, processes it in several databases, then distributes customized reports to its customers. Behind the scenes, more than 10,000 jobs are run to transfer files securely, encrypt/decrypt files, and generate reports. The IT team had to manage an abundance of servers to run individual tasks, which created mounting overhead as the business grew.
Camden Asset Management needed to continuously convert accounting and trading data, pull in financial data from various sources, and distribute P&L reports to its internal and external customers. They used a mix of SQL Agent, Windows Task Scheduler, and open source scheduler SOS to run the thousands of jobs necessary for these business processes, but “simple timed schedulers” made error handling nearly impossible.