Integrate SQL Jobs with enterprise workloads.
Free TrialYour database team is under pressure. Manual scheduling of SQL jobs threatens deadlines as jobs wait on the detection of file arrivals, alerts and other events. Maintaining SQL jobs and enterprise workloads with multiple tools wastes valuable IT resources while unmonitored, standalone SQL database jobs and scripts can expose enterprise security controls. Moreover, a lack of alignment between DBAs and application managers adds to operational overheads.
CA Automic Workload Automation enables you to execute SQL commands including DDL, DML, stored procedures and DBA functions without having to use an external command line tool. CA Technologies advanced security model simplifies your database administration, making security concerns, unwieldy tools, wrapper scripts and confusing evaluations of the past. Tasks can proceed in a uniform manner within the framework of enterprise workload automation.
Removing unnecessary manual steps and bringing SQL jobs into automation workflows enables IT Operations teams to gain the agility businesses now demand for digital transformation.
Uses an interface tailored to support the different types of database jobs
A powerful event object that allows the initiation of a job or process flow based on the value of a database query
Integration with databases like SQL Server, Oracle, IBM DB2, MySQL, SAP Hana, Sybase, Informix, Ingres
Executes multiple database jobs in parallel by creating a separate thread for every job
The results of a transaction are made available as a job report; date and time stamps are provided in a uniform format for all databases
Integrated file transfer ensures timely, accurate and secure data transfer
Simplifies the management of IT workload across multiple and heterogeneous database instances
Reduces errors and delays by removing reliance on custom scripts
Enhances visibility of database jobs and other business application workload, end to end
Encrypts passwords in login objects for greater security and avoids multiplication of local scripts
We are no longer missing SLAs that we were missing in the past, so that enables our business to provide much better deliverables to our end clients in a much more reliable way. Jeff Schmidt
, Senior Automation Engineer , 84.51°