ActiveBatch supports the creation of "end to end" workflows that incorporate and
integrate Microsoft SQL Server functions as job steps within workflows. Among the
SQL Server functions that are included with each ActiveBatch Job Scheduler system
are:
- Backup
- DTS Package
- SQL Server Job
- SQL Server Report
- SSIS Package
- T-SQL Block
SQL Server's scheduling capabilities are extended by the ActiveBatch Job Scheduler
combining and managing SQL Server functions with other workflows or jobs. ActiveBatch
supports the running of SQL Server jobs on its server or on other systems running
the SQL Server client. In addition ActiveBatch gives the designer a choice between
agent and "agent-less" access to the SQL Server systems for invoking the SQL Server
task, and incorporating these tasks into "end to work" flows on other systems and
additional applications.
SQL Server users can now receive the full benefit from ActiveBatch's ability to
support:
- Job chainingacross multiple SQL Servers giving operators the ability to communicate
and manage multiple SQL Server jobs.
- Single point of schedulingto easily integrate SQL Server jobs with other
scripts and applications all managed through the ActiveBatch job scheduler.
- Pass informationfrom SQL Server databases to other servers, databases, or
applications.
- Improved reliabilitythrough ActiveBatch non cluster failover, checkpoint
restarts, and workload balancing.
- Integrating File, Resource, and Variable Constraintswith SQL jobs, DTS and
SSIS Packages, to reduce errors and ensure that data is in fact valid.
- Customizable and flexible alertingfor SQL server jobs finally give organizations
peace of mind knowing that their data will be up to date each and every day.
ActiveBatch adds its advanced scheduling capabilities, such as Checkpointing, constraints
or dependencies, monitoring or alerting or from the
Integrated Jobs Library. such as FTP, SFTP, FTPS or even Web Services to
your workflows by coupling the business execution logic found in SQL Server with
the robust framework that ActiveBatch has to offer.
ActiveBatch can help your organization improve the integration of SQL Server with
other jobs, scripts and applications into workflows that has been proven to reduce
errors by eliminating complex scripting, improve service levels and allowing for
a reduced cost of operations through centralized and integrated control of disparate
and disconnected Systems and applications.
Check our
Integrated Jobs Library details for more specific information.
Request
Info:
