February 16, 2021 at 8:01 pm
I’m having some trouble figuring out the kind of support for Linux that the SQL Server 2019 job scheduler has. It’s clear that the job scheduling procedure API, and SQL Server Agent have both been ported to Linux and appear to work. But there are a limited number of kinds of job steps supported. These “kinds” of job steps are known as “subsystems” in MS jargon. So when you define a job step, you have to specify what type of task it is.
As documented by Microsoft, these subsystems are not supported by the Linux port of SQL Server 2019: CmdExec, PowerShell, Replication Distributor, Snapshot, Merge, Queue Reader, SSIS, SSAS, SSRS.
So that’s clear enough, but then what are the supported subsystems? There are lots of examples of T-SQL steps that can be defined for a job, but are there others? In particular, can I call out to the OS to run an artbitrary shell script (sh/ksh/bash)? Is there a definitive list of subsystem types that are supported? I do realize that I can infer the answer by taking the list of types (subsystems) that are supported on Windows and then deduct the list of types that are not supported. But has Microsoft published the definitive list of subsystems supported for Linux?
I ask because it seems really odd to me that access to the OS to run a command would not be supported by the Linux port of the scheduler.
February 17, 2021 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 17, 2021 at 8:51 pm
treat it like an sql query. Find whats supported in windows EXCEPT the list you provided.
February 18, 2021 at 6:20 am
Life is a journey, you don’t care about the destination, you care about the scenery along the way and the mood of seeing the scenery.
Others laughed at me as crazy, I laughed at others and couldn't see through.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply