Policies & Jobs
PowerShell 3
| Intermediate
- 11 videos | 1h 9m 31s
- Earns a Badge
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 59sIn this video, you will use cmdlets to create and configure user-defined policies in PowerShell. FREE ACCESS
-
5m 10sIn this video, find out how to evaluate policies and output the results in PowerShell. FREE ACCESS
-
3. PowerShell Job Step3m 29sDuring this video, you will learn how to create a PowerShell Job Step inside a SQL Server Agent Job. FREE ACCESS
-
4. PowerShell from SSMS6m 40sIn this video, you will use Microsoft PowerShell to populate a table created in Microsoft SQL Server Management Studio using SQLCMD mode. FREE ACCESS
-
5. Execute SQL Scripts from File5m 22sLearn how to execute SQL scripts from file locations using PowerShell. FREE ACCESS
-
6. Create SQL Agent Job6m 30sIn this video, learn how to create SQL Server Agent Jobs using PowerShell. FREE ACCESS
-
7. Execute SQL Agent Job8m 40sIn this video, learn how to run existing SQL Server Jobs in PowerShell. FREE ACCESS
-
8. Retrieve SQL Agent Job History3m 38sIn this video, find out how to retrieve SQL Server Agent Job histories using PowerShell. FREE ACCESS
-
9. PowerShell Variables12m 13sIn this video, you will learn how to use PowerShell variables. FREE ACCESS
-
10. Piping4m 29sLearn how to use piping in PowerShell. FREE ACCESS
-
11. Use PowerShell Utility to Create Stored Procedure5m 23sFind 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.
