Defining Microsoft SQL Jobs

There are three types of Microsoft SQL Server Adapter jobs that you can define in TA:

• MSSQL Job – Direct inclusion of T-SQL statements.

• Database Job – Includes one or more steps of various database task types, including this:

T-SQL

ActiveX Scripts

Operating system command

Replication distributor

Replication merge

Replication queue reader

Replication snapshot

Replication transaction-log reader

SQL Server analysis services command

SQL Server analysis services query

• Existing Database Job – Includes jobs already defined to run under the adapter.

  Note: Before creating and scheduling Microsoft SQL jobs, you should add the Microsoft SQL database user to TA, define your Microsoft SQL connection(s). These topics are covered in Configuring the Adapter.