Policies & Jobs

PowerShell 3    |    Intermediate
  • 11 Videos | 1h 11m 31s
  • Earns a Badge
Likes 10 Likes 10
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

  • Playable
    1. 
    Policies
    7m 59s
    UP NEXT
  • Playable
    2. 
    Evaluate the SQL Policy
    5m 10s
  • Locked
    3. 
    PowerShell Job Step
    3m 29s
  • Locked
    4. 
    PowerShell from SSMS
    6m 40s
  • Locked
    5. 
    Execute SQL Scripts from File
    5m 22s
  • Locked
    6. 
    Create SQL Agent Job
    6m 30s
  • Locked
    7. 
    Execute SQL Agent Job
    8m 40s
  • Locked
    8. 
    Retrieve SQL Agent Job History
    3m 38s
  • Locked
    9. 
    PowerShell Variables
    12m 13s
  • Locked
    10. 
    Piping
    4m 29s
  • Locked
    11. 
    Use PowerShell Utility to Create Stored Procedure
    5m 23s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 43 Likes 43  
Likes 166 Likes 166  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 166 Likes 166  
Likes 31 Likes 31  
Likes 14 Likes 14