Policies & Jobs

PowerShell 3    |    Intermediate
  • 11 videos | 1h 9m 31s
  • Earns a Badge
Rating 4.5 of 19 users Rating 4.5 of 19 users (19)
SQL PowerShell can utilize scripting to assist with the automation of frequent management tasks. Learn about policies and jobs and how to script them using PowerShell.

WHAT YOU WILL LEARN

  • Use cmdlets to create and configure user defined policies in powershell
    Evaluate policies and output the result in powershell
    Create a powershell job step inside a sql server agent job
    Use microsoft powershell to populate a table created in microsoft sql server management studio using sqlcmd mode
    Execute sql scripts from file locations in powershell
    Create sql server agent jobs in powershell
  • Execute existing sql server jobs in powershell
    Retrieve sql server agent job histories in powershell
    Use powershell variables
    Use piping in powershell
    Use the powershell utility to create a stored procedure

IN THIS COURSE

  • 7m 59s
    In this video, you will use cmdlets to create and configure user-defined policies in PowerShell. FREE ACCESS
  • 5m 10s
    In this video, find out how to evaluate policies and output the results in PowerShell. FREE ACCESS
  • Locked
    3.  PowerShell Job Step
    3m 29s
    During this video, you will learn how to create a PowerShell Job Step inside a SQL Server Agent Job. FREE ACCESS
  • Locked
    4.  PowerShell from SSMS
    6m 40s
    In this video, you will use Microsoft PowerShell to populate a table created in Microsoft SQL Server Management Studio using SQLCMD mode. FREE ACCESS
  • Locked
    5.  Execute SQL Scripts from File
    5m 22s
    Learn how to execute SQL scripts from file locations using PowerShell. FREE ACCESS
  • Locked
    6.  Create SQL Agent Job
    6m 30s
    In this video, learn how to create SQL Server Agent Jobs using PowerShell. FREE ACCESS
  • Locked
    7.  Execute SQL Agent Job
    8m 40s
    In this video, learn how to run existing SQL Server Jobs in PowerShell. FREE ACCESS
  • Locked
    8.  Retrieve SQL Agent Job History
    3m 38s
    In this video, find out how to retrieve SQL Server Agent Job histories using PowerShell. FREE ACCESS
  • Locked
    9.  PowerShell Variables
    12m 13s
    In this video, you will learn how to use PowerShell variables. FREE ACCESS
  • Locked
    10.  Piping
    4m 29s
    Learn how to use piping in PowerShell. FREE ACCESS
  • Locked
    11.  Use PowerShell Utility to Create Stored Procedure
    5m 23s
    Find out how to use the PowerShell Utility to create a stored procedure. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Automation & Scripting
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Book PowerShell Advanced Cookbook: Enhance Your Scripting Skills and Master PowerShell with 90+ Advanced Recipes
Book PowerShell in 7 Days: Learn essential skills in scripting and automation using PowerShell

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Azure Data Fundamentals: Non-relational Data Workloads
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)
Course MD-102: Configuring Remote Management for Windows Clients
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course VMware VCP-DCV vSphere 7: Managing & Deploying VMs
Rating 4.8 of 98 users Rating 4.8 of 98 users (98)