A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
Hi @LauraC ,
This is already an old article, not to mention that the version of SSMS and SQL Server used in it are probably no longer supported, if you want to use it to learn or use, it is recommended to find the job you need, and
Using SMO With PowerShell To Obtain SQL Server Job Information
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.