CODEWITHSUNDEEP
sql-serverpowershellubuntu
Aref Karimi
Aref Karimi

Reputation: 1890

SQL Server 2017 on Linux. Job with a Powershell Step

I have a SQL Server 2017 Standard on Ubuntu 20.04 and I would like to automate the backup process using a SQL Server Agent Job. This job will create the backup file and then will upload it to AWS S3. To copy the .bak file to AWS S3 I would like to use AWS Tools for PowerShell (which I have installed on the EC2 instance) however I don't see the "PowerShell" task type in the SQL Server Job. This has always existed in SQL Server on Windows.

enter image description here

Is there something I can do to add a PowerShell step type to SQL Server on Linux?

Upvotes: 0

Views: 189

Answers (1)

Thom A
Thom A

Reputation: 95829

Powershell execution is not supported on SQL Agent on SQL Server on Linux 2017; as noted in the documentation. This is true for 2019 as well.

Upvotes: 1

Related Questions