Gets the details of all of the Jobs for the given SQL Server Instance.

Syntax

Get-SqlMonitorJob [[-Instance] <Instance>] [[-Name] <string>] [<CommonParameters>]

Description

The Get-SqlMonitorElasticPool cmdlet gets details of Jobs from a SQL Monitor Server.

Without parameters, this cmdlet gets details of all Jobs.

Connect-SqlMonitor must be called before this cmdlet.

Parameters

-Instance <Instance>

The Instance to limit results to. For more information, see https://documentation.red-gate.com/sm/api/powershell-cmdlet-reference/get-sqlmonitorinstance.

-Name <String>

The Job name to match.

-ProgressAction <ActionPreference>

{{ Fill ProgressAction Description }}

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see http://technet.microsoft.com/en-us/library/hh847884.aspx.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

• [Instance] For more information, see https://www.red-gate.com/SM13/powershell-custom-types#CustomTypes-Instance.

Return values

The output type is the type of the objects that the cmdlet emits.

• [Job] For more information, see https://www.red-gate.com/SM13/powershell-custom-types#CustomTypes-Job.

Examples

-------------------------- EXAMPLE 1 --------------------------

Get-SqlMonitorJob

-------------------------- EXAMPLE 2 --------------------------

Get-SqlMonitorJob -Instance $instance

-------------------------- EXAMPLE 3 --------------------------

Get-SqlMonitorJob -Name "ExampleJobName"

-------------------------- EXAMPLE 4 --------------------------

Get-SqlMonitorJob -Instance $instance -Name "ExampleJobName"