The MVP version includes support for running SSIS package job steps.
There are a few other types of job step available:
Operating system (CmdExec)
PowerShell
SQL Server Analysis Services Command
SQL Server Analysis Services Query
SQL Server Integration Services Package
Transact-SQL script (T-SQL)
I'm not suggesting that we support them all (at least not yet/until there's a strong appetite for their support), but Transact-SQL steps seem like the most common other use case we could implement.
Considerations:
How do we support arbitrary blocks of SQL code in a TOML document?
The target database should be a configurable option in the TOML file
The MVP version includes support for running SSIS package job steps.
There are a few other types of job step available:
I'm not suggesting that we support them all (at least not yet/until there's a strong appetite for their support), but Transact-SQL steps seem like the most common other use case we could implement.
Considerations: