EncartaLabs

BMC Control-M for Databases

( Duration: 1 Day )

The BMC Control-M for Databases training course provides BMC Control-M administrators and schedulers with the concepts and knowledge required to install, configure, perform account setup, and start using BMC Control-M for Databases to define jobs that automate database tasks.

By attending BMC Control-M for Databases workshop, Participants will learn to:

  • Connect to supported databases from a single computer with a secure login
  • Define and monitor stored procedure, SQL script, SQL Server Integration Services (SSIS) Package, and Open Query database jobs
  • Integrate database jobs with other Control-M jobs into a common scheduling environment
  • Introduce all Control-M capabilities to database management activities

  • BMC Control-M Administrators
  • BMC Control-M Schedulers
  • Other IT professionals with an interest in the BMC Control-M solution

COURSE AGENDA

1

Describe the purpose and benefits of BMC Control-M for Databases

2

Acquire the files needed to install BMC Control-M for Databases

3

Install BMC Control-M for Databases

4

Perform post-installation tasks, including the definition of BMC Control-M for Databases accounts

5

Define jobs that schedule the execution of stored procedures and SQL scripts

6

Define new SQL queries on-the-fly in job definitions

7

Manage SYSOUT files from BMC Control-M for Databases jobs

8

Describe BMC Control-M for Databases support for MSSQL Extraction, Transform and Loading (ETL) services, and SSIS packages

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 3,500 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 20,000 corporate candidates across india and abroad
  • All our trainings are conducted in workshop mode with more focus on hands On

View our other course offerings by visiting www.encartalabs.com/course-catalogue

Contact us for delivering this course as a public/open-house workshop for a group of 10+ candidates at our venue

Top