UVA Health Cures SQL Agent Ailments with JAMS

Hosting critical applications and business processes on multiple platforms had created a variety of pressure points for UVA Health’s workload automation tools. Failures and delays caused by the shortcomings of these tools were unacceptable.


Real Time and Event Driven Automation: JAMS at Seminole Electric

Seminole’s transition from mainframe processing to distributed processing presented the electric cooperative’s IT team with an important choice. Continue to invest in Control-M, the cooperative’s original mainframe scheduling tool, or start to look at alternative solutions.



Event Driven Dynamics AX Automation

Seminole Electric Cooperative is one of the largest electric power generation and transmission facilities in the United States. Initially, Seminole would run its Dynamics AX batch jobs at 11:00 PM, in the hopes that other processes would be done by the time Dynamics jobs started. A Thursday backup that included weekly consolidation of several databases frequently ran long, causing Dynamics jobs to fail. The Seminole team would often spend Friday mornings troubleshooting and re-running jobs.


Automated ISIR Load Processing and Aid Packaging

When the University of Mary Washington (UMW) first moved to a Ruffalo Noel Levitz (RNL) net tuition discounting program, it took their team 8-10 hours a day to manually run ISIR loads through the 55 aid packaging groups (each a Banner process) to produce letter files. The University found they needed to automate the aid process in order to scale – hiring more personnel wasn’t an option.

With JAMS, a file trigger automatically kicks off the ISIR load import once a new file is ready, moves the ISIR load through hundreds of decision points and 120 packaging groups within the RNL matrix, and even creates letter files for the University to print letters. The whole end-to-end process runs in JAMS, and only takes about 20 minutes for each ISIR file – no manual processing necessary.


Secure EDM and ETL for Trading Systems

Jupiter is a fund management group, with institutional and retail clients in the UK, Europe, and the Asia Pacific region. They were using a mixture of SQL Agent, Windows Task Scheduler, ad-hoc PowerShell Scripts, and Biztalk to run over 1,000 EDM, FTP, and ETL processes across hundreds of servers. The decentralized processing meant Jupiter had to spend considerable manual time just to monitor what was running, ensure processes were secure, and verify that they were compliant.

With JAMS, Jupiter’s processes are managed and visible from a single console. The run-time encryption, native history logging and audit trail, and Active Directory integration in JAMS ensure Jupiter’s processes run securely. JAMS has given the business room to scale from 1,000 to 36,000 daily processes spread across CashView batch jobs, It Ops, SCOM Alerting, Trading Systems, BI, Managed Fund Accounting, and even API-based self-service jobs that business users can launch from a SharePoint site.


Automating SAP Jobs

U.S. Sugar used a combination of the SAP Job Scheduler and various FTP applications’ jobs to execute its data extracts and data processes. To run jobs reliably, the team needed to build ample padding into the schedule to allow the SAP jobs to finish before the file transfers started.


Automated File Transfer Plus Batch

Maritz designs and operates employee recognition and reward programs, sales channel incentive programs, and customer loyalty programs. To execute thousands of daily file transfers and the batch processes necessary upon receipt required an application stack that spread across 3 separate applications. JAMS consolidated all scheduling and automation – both Windows and Linux jobs – into one console, saving the company hours of overhead.

JAMS runs more than 800 jobs with excellent reliability. Maritz leverages JAMS central monitor to view its entire schedule of jobs and keeps business users informed of the status of critical jobs with JAMS alerts and notifications.


Automated Order Processing

TGW (The Golf Warehouse) needed an efficient method to move orders from its ERP system to its warehouse system. This process uses an EDI to gather related data from the ERP database and transfer it (via SFTP) to cloud-based tools for a comprehensive customer experience.

TGW uses JAMS to combine PowerShell, SQL*Plus, and Ecometry jobs into unified business processes. Their ability to build workflows in a single console has greatly reduced the manual hours needed to connect jobs on different platforms.


End-to-End Business Processing

A U.S. government agency’s infrastructure group was inundated with many menial tasks, and needed its complex processes to have “reliability of programming”. With JAMS orchestrating each task, the agency has brought uniformity to the time and conditions under which processes execute.