Advanced Systems Concepts, Inc.
31 Case Studies
A Advanced Systems Concepts, Inc. Case Study
Graymont Services, a North American lime and construction materials producer based in Richmond, BC, faced unreliable end-to-end data warehouse and IBM Cognos BI processing caused by a patchwork of scripts and point schedulers (Cron, Task Scheduler, SQL Server Agent). This fragmentation left reporting late or incorrect, batch success rates around 30%, and IT staff—especially Paul Epp, IS Manager—frequently waking to restart failed jobs. To address this, Graymont selected Advanced Systems Concepts, Inc.'s ActiveBatch (including the ActiveBatch Extension for Cognos) for centralized job scheduling and automation.
Advanced Systems Concepts, Inc. implemented ActiveBatch’s System View, Queue Management and Cognos integration to consolidate scheduling, enable parallel execution, and automate Cognos report workflows. The solution cut batch runtimes by 55%, raised processing success from ~30% to over 95%, reduced nightly failures from nearly every night to about once a month, and dramatically lowered maintenance overhead—improving IT productivity and report reliability.
Paul Epp
IS Manager and Cognos Application Manager