Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Get-SCDWJobModule

Updated: November 1, 2013

Applies To: System Center 2012 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager

Get-SCDWJobModule

Returns detailed status information about the modules of the specified job.

Syntax

Parameter Set: JobNameSet
Get-SCDWJobModule [-ComputerName <String> ] [-JobName <String> ] [-NumberOfBatches <Int32> ] [ <CommonParameters>]

Parameter Set: JobIDSet
Get-SCDWJobModule -JobBatchID <Nullable`1> [-ComputerName <String> ] [-ModuleID <Nullable`1> ] [-ModuleName <String> ] [ <CommonParameters>]

Parameter Set: JobNameModuleIDSet
Get-SCDWJobModule [-ComputerName <String> ] [-JobName <String> ] [-ModuleID <Nullable`1> ] [-NumberOfBatches <Int32> ] [ <CommonParameters>]

Parameter Set: JobNameModuleNameSet
Get-SCDWJobModule [-ComputerName <String> ] [-JobName <String> ] [-ModuleName <String> ] [-NumberOfBatches <Int32> ] [ <CommonParameters>]




Detailed Description

The Get-SCDWJobModule cmdlet returns detailed status information about the modules of the specified job. Each data warehouse job comprises multiple subprocesses, called modules, which perform the individual work items that are associated with the parent job.

For updated information about this cmdlet, see Get-SCDWJobModule.

Parameters

-ComputerName<String>

Specifies the name of the computer on which the System Center Data Access service is running. You can omit this parameter only if the System Center Data Access Service is running on the same computer that has Service Manager installed.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-JobBatchID<Nullable`1>

Specifies the job’s batch ID for which to retrieve all associated modules. You can use the Get-SCDWJob cmdlet to retrieve a job’s batch ID. By specifying the JobBatchID parameter, you retrieve all the modules of the specified job.


Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-JobName<String>

Specifies the name of the specific Extract, Transform, or Load job for which you want to get status.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ModuleID<Nullable`1>

Specifies the ID of the job module for which to retrieve status. This must be a valid module ID for the specified job. This parameter cannot be used in conjunction with the JobModule parameter.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ModuleName<String>

Specifies the name of the job module for which to retrieve status. This name must be a valid module name for the specified job. This parameter cannot be used in conjunction with the ModuleID parameter.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-NumberOfBatches<Int32>

Specifies the number of batches for which to return status.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters.

Inputs

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

  • None.

    You cannot pipe input to this cmdlet.


Outputs

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

  • Microsoft.EnterpriseManagement.OrchestrationJobModule

Examples

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

This command displays module information about the Transform.common job.


PS C:\>Get-SCDWJobmodule -ComputerName serverDW7 -JobName Transform.common -NumberOfBatches 4

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

This command displays module information for jobs using a specified job batch ID.


PS C:\>Get-SCDWJobModule –ComputerName serverDW7 -JobBatchID 4126 -NumberOfBatches 4

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

This command displays module information for a specific job and module by its module ID.


PS C:\> Get-SCDWJobModule -ComputerName IXSMTestDW -JobName DWMaintenance -ModuleID 7 -NumberOfBatches 12

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

This command displays module information for a specific job and module by its module name.


PS C:\> Get-SCDWJobModule -ComputerName IXSMTestDW -JobName MPSyncJob -ModuleName "Clean Up" -NumberOfBatches 12 

-------------------------- EXAMPLE 5 --------------------------

This command lists module error counts, but only if an error count is greater than zero.


PS C:\> Get-SCDWJobModule -ComputerName serverDW7 -NumberOfBatches 12| Where-Object {$_.ModuleErrorCount -gt 0} | Format-Table -Property JobName, ModuleID, ModuleErrorCount -AutoSize

-------------------------- EXAMPLE 6 --------------------------

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


PS C:\> Get-SCDWJobModule -ComputerName serverDW7 –NumberOfBatches 4| Select-Object -Property BatchId, CategoryId, CategoryName, CreationTime, Description, JobId, JobModuleId, JobName, ManagementGroup, ManagementGroupId, ModuleCreationTime, ModuleDescription, ModuleErrorCount, ModuleErrorSummary, ModuleId, ModuleModifiedTime, ModuleName, ModuleRetryCount, ModuleStartTime, ModuleTypeId, ModuleTypeName, NotToBePickedBefore, Status | Export-Csv C:\TEMP\JobModuleData.csv

Related topics

 
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.