Analysis: Workload automation tools

There’s never enough time in the day, even more so if the organization is growing and operates across multiple time zones.

That was the problem faced by the IT department of B.C.’s Graymont Services, which says it’s the second largest supplier of lime and lime-based products in North America.

The material is used in a wide variety of industries, from the processing of gold and copper to making steel to municipal water treatment plants.

Paul Epp, the company’s business analytics manager, recalled that until seven years ago was able to cope with manually scheduling overnight jobs including backing up data from its J.D. Edwards enterprise resource management suite and processing reports through Cognos BI and Enterprise Planning applications.

But with some 400 data movements a night that had to be choreographed over six hours and offices across the country, time was a problem

“We had built up a very complex ETL process to pull all of our data into our data warehouses,” he said. But “it was becoming very difficult to manage when there are errors, difficult to make changes without introducing errors. And we definitely had a constraint with the systems we had — there wasn’t enough time in our night window to get all the jobs done.”

Eventually the company turned to one of the many job scheduling suites on the market, ActiveBatch from Advanced Systems Concepts Incd.

It gave Graymont the capability to scale our other systems across multiple servers, and scale the data integrations across many of the company’s applications, including JDE and Cognos, Epp said. It would also give much needed logging and error checking, as well as daily reports.

ActiveBatch, now on version 9, offers a wide range of extensions that work with Microsoft applications including System Center Operations Manager and related components, Active Directory, SQL Server, Exchange, and the Microsoft Azure cloud platform.

There’s no shortage of workload automation software vendors, including BMC Control-M, CA Workload Automation, Cisco Tidal Enterprise Scheduler, Stonebranch, and IBM Tivoli Workload Scheduler.

See this sidebar for highlights

In looking for the right solution IT managers have to remember that the cloud has had a big impact on scheduling jobs, notes Steve Brassen, managing research director of Enterprise Management Associates. Solutions have take into account that workloads are placed in increasingly dynamic environments, with options including virtual servers, private/public/hybrid clouds.

A solution may also have to be able to take into account whether the infrastructure can support all these options, whether the organization tiers workloads and scheduling requirements that may change week to week.

Some include workload analytics that can aggregate jobs into streams, and connect those streams to business goals.

Remember, too, that these days for some organizations there is no night window for processing jobs – staff may be accessing apps from around the world at any time “so placing those workloads has to be more meticulous than it was before.”

And while solutions feature sets are increasing, enterprises should also consider how easy a suite is to deploy, how much maintenance it requires and price.

Robin Reddick of BMC’s solutions marketing team, mentioned in an interview that giving members of business units rather that operations the power to self service the running of reports is increasingly important.

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Howard Solomon
Howard Solomon
Currently a freelance writer, I'm the former editor of ITWorldCanada.com and Computing Canada. An IT journalist since 1997, I've written for several of ITWC's sister publications including ITBusiness.ca and Computer Dealer News. Before that I was a staff reporter at the Calgary Herald and the Brampton (Ont.) Daily Times. I can be reached at hsolomon [@] soloreporter.com

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now