When you define steps for a job, you have to determine the type of step. SQL Enterprise Job Manager handles the following types of steps:

  • Executable programs and operating systems commands.
  • Transact-SQL statements, including stored procedures and extended stored procedures.
  • Powershell scripts.
  • Replication tasks:
    • Replication Distributor
    • Replication Merge
    • Replication Queue Reader
    • Replication Snapshot
    • Replication Transaction-Log Reader. 

For more information about these job steps types, click here.

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels