Robust Job Libraries and Support

Robust job libraries and support

To simplify deployment of data warehouse computing tasks, look for a job scheduling solution with a robust job library that allows work loads to be easily assembled. A good library will reduce or even eliminate the custom scripting that eats up manpower and complicates workflow deployment.

Also, look for suitable support for your particular IT environment. Whether you operate a mix of Linux, Unix or Windows, are heavy into Java, Web Services, Oracle or SQL Server, use OpenPGP to encrypt and decrypt tasks or Secure Shell (SSH) to protect data exchange between devices, your scheduling application should be robust enough to handle it all.

The demands on today's data warehouses are more stringent and up to the minute than ever before. With a strong job scheduler at work, it's possible to accommodate these demands while extending human and computing resources-and even improving return on infrastructure. Whether you have a job scheduler in place or are considering adding one, leverage its capabilities wisely and you'll find your goal of a near real-time data warehouse becoming a reality.

Ben Rosenberg is founder and President at Advanced Systems Concepts. An expert in enterprise-class IT automation and system utilization solutions, Ben has nearly 40 years of experience in engineering and marketing system software products across Windows, Unix, OpenVMS and mainframe platforms. Ben can be reached at brosenberg@advsyscon.com.