Get-SCDWJob

Gets the list of all data warehouse jobs.

Syntax

Get-SCDWJob [-ComputerName <String>] [-Credential <PSCredential>] -JobBatchID <Int32> [<CommonParameters>]
Get-SCDWJob [-ComputerName <String>] [-Credential <PSCredential>] [-JobName <String>]
 [-NumberOfBatches <Int32>] [<CommonParameters>]

Description

The Get-SCDWJob cmdlet gets the list of all data warehouse jobs, displaying information such as the status of these jobs.

Examples

Example 1: List data warehouse jobs

PS C:\>Get-SCDWJob -ComputerName "serverDW72" â€"NumberOfBatches 4

The command in this example lists data warehouse jobs.

Example 2: Get jobs by job name

PS C:\>Get-SCDWjob -ComputerName "serverDW72" -JobName "Transform.Common" -NumberOfBatches 2

This command gets Transform.Common jobs.

Example 3: Get jobs by status and batch ID

PS C:\>Get-SCDWJob -ComputerName "ServerDW72" â€"NumberOfBatches 4| Where-Object {$_.Status -eq "Not Started" -and $_.BatchID -gt 800}

This command gets jobs that have a status of 'Not Started' and that have a batch ID greater than 800.

Example 4: Get job property values and save them to a CSV file

PS C:\>Get-SCDWJobModule -ComputerName "serverDW72" -NumberOfBatches 4 | Select-Object -Property BatchId, CategoryId, CategoryName, CreationTime, Description, EndTime, Id, IsEnabled, IsRecuring, LastRunTime, ManagementGroup, ModifedTime, Modules, Name, NextRuntime, Schedule, ScheduleRuleID, SourceTypeName, StartTime, Status, StatusID, WorkflowRuleID | Export-Csv "C:\DWData\JobData.csv"

This command gets all the job property values and saves the results to a CSV file.

Parameters

-ComputerName

Specifies the name of the computer on which the System Center Data Access service is running. The user account that is defined in the Credential parameter must have access rights to the specified computer. You can omit this parameter only if the System Center Data Access Service is running on the same computer that has Service Manager installed.

Type:String
Aliases:CN
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Credential

Specifies the credentials to use when you are connecting to the server on which the System Center Data Access service is running. The provided user account must have access to that server.

Type:PSCredential
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-JobBatchID

Specifies the batch ID of the job run to return. A job batch ID is generated by the system for each individual run of a job. This integer value is unique across job runs of all types. This parameter cannot be used in conjunction with the JobName parameter.

Type:Int32
Required:True
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-JobName

Specifies the name of the Data Warehouse job instance for which you want to get status. This parameter cannot be used in conjunction with the JobBatchID parameter.

Type:String
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-NumberOfBatches

Specifies the number of batches for which you want to display status. This value must be greater than or equal to 1.

Type:Int32
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

None.

You cannot pipe input to this cmdlet.

Outputs

Microsoft.EnterpriseManagement.OrchestrationJob