dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Get-DbaAgentJob

Gets SQL Agent Job information for each instance(s) of SQL Server.

Screenshots

Examples

To return all SQL Agent Job on the local default SQL Server instance.

Get-DbaAgentJob -SqlInstance localhost

To return all SQl Agent Job for the local and sql2016 SQL Server instances.

Get-DbaAgentJob -SqlInstance localhost, sql2016

Author

This command was created by Garry Bargsley. You can find Garry on Twitter and his blog.

Get-Help

From PowerShell, execute Get-Help Get-DbaAgentJob -Detailed for more information on this function.

Source Code

Want to see the source code? View Get-DbaAgentJob.ps1 on GitHub
 

Related commands