Get-SCDWJob
Gets the list of all data warehouse jobs.
Syntax
Get-SCDWJob
[-JobName <String>]
[-NumberOfBatches <Int32>]
[-ComputerName <String>]
[-Credential <PSCredential>]
[<CommonParameters>]
Get-SCDWJob
-JobBatchID <Int32>
[-ComputerName <String>]
[-Credential <PSCredential>]
[<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 |
Position: | Named |
Default value: | None |
Required: | False |
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 |
Position: | Named |
Default value: | None |
Required: | False |
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 |
Position: | Named |
Default value: | None |
Required: | True |
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 |
Position: | Named |
Default value: | None |
Required: | False |
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 |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Inputs
None.
You cannot pipe input to this cmdlet.
Outputs
Microsoft.EnterpriseManagement.OrchestrationJob