View running batch jobs

Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.BatchFramework.ViewRunningJobs (Task)

View a list of running batch jobs.

Element properties:

Member Modules:

Source Code:

<Task ID="Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.BatchFramework.ViewRunningJobs" Accessibility="Public" Enabled="true" Target="MicrosoftDynamicsAX6ManagementPackClassLibrary!Microsoft.Dynamics.AX6.ManagementPack.ClassLibrary.BatchFramework" Timeout="300" Remotable="true">

  <Category>Operations</Category>

  <WriteAction ID="Script" RunAs="MicrosoftDynamicsAX6ManagementPackClassLibrary!Microsoft.Dynamics.AX6.ManagementPack.ClassLibrary.AxDbReaderAccount" TypeID="System!System.CommandExecuter">

    <ApplicationName>%windir%\system32\windowspowershell\v1.0\powershell.exe</ApplicationName>

    <WorkingDirectory/>

    <CommandLine>-Command ".\Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.ViewRunningJobs.ps1 '$Target/Property[Type="MicrosoftDynamicsAX6ManagementPackClassLibrary!Microsoft.Dynamics.AX6.ManagementPack.ClassLibrary.BatchFramework"]/ServerName$' '$Target/Property[Type="MicrosoftDynamicsAX6ManagementPackClassLibrary!Microsoft.Dynamics.AX6.ManagementPack.ClassLibrary.BatchFramework"]/DatabaseName$'"</CommandLine>

    <TimeoutSeconds>50</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files>

      <File>

        <Name>Microsoft.Dynamics.AX6.ManagementPack.AOS.Monitoring.ViewRunningJobs.ps1</Name>

        <Contents><Script>

            function GetLibraryPath($key)

            {

                foreach ($sub in $key)

                {

                    $aosPath = $sub.GetValue("AOSPath")

                    $tokens = $aosPath.Split('\')

                    $libPath = ""

                    foreach ($token in $tokens)

                    {

                        if($token -ne "Server")

                        {

                            $libPath = $libPath + $token + "\"

                        }

                        else

                        {

                            $libPath = $libPath + $token + "\Common\"

                            return $libPath

                        }

                    }

                    break

                }

            }



            function WriteErrorToEventLog($functionName)

            {

                $errorRecord = [string]::Format("{0}`n{1}`n{2}`n{3}`n",$Error[0].Exception.Message,$Error[0].InvocationInfo.Line,$Error[0].InvocationInfo.PositionMessage,$Error[0].Exception)

                if($Error[0].Exception.InnerException -ne $null) {

                    $errorRecord = $errorRecord + $Error[0].Exception.InnerException }            

                $scomapi.LogScriptEvent("Exception in " + $functionName, 300, 1, "`n`nError: " +$errorRecord)

                $Error.Clear()                    

            }    



            try

            {

                $dbServer = $args[0]

                $dbName = $args[1]

                $scomapi = new-object -comObject "MOM.ScriptAPI"

            }

            catch

            {

                WriteErrorToEventLog "Initializing scom API object"

                Write-Host $localizedMessages.taskCompletionError

                return

            }

            try

            {

                $aosRegPath = "HKLM:\SYSTEM\CurrentControlSet\Services\Dynamics Server\6.0"

                $key = Get-ChildItem $aosRegPath

        

                $libraryPath = GetLibraryPath $key

                $localizedFilePath = $libraryPath

            

                $dllLoadPath = $libraryPath + "Microsoft.Dynamics.Ax.ManagementPackSupport.dll"

                $libraryPath = $libraryPath + "Microsoft.Dynamics.Ax.ManagementPackSupport.ps1"

        

                #PSUICulture is in the format &lt;language&gt;-&lt;region&gt;. get language

                $language = ($PsUICulture.Split('-'))[0]

                if($language.ToUpper() -eq "ZH") { $language = "ZH-HANS" }

                if($language.ToUpper() -eq "PT") { $language = "PT-BR" }

                

                .$libraryPath

                Import-LocalizedData -BindingVariable localizedMessages -BaseDirectory $localizedFilePath -FileName Microsoft.Dynamics.Ax.ManagementPackSupport.psd1 -UICulture $language

            

                $eventBatchTaskRunnnigJobsStarted = "PowerShell script for View Running Jobs task executed"

                $scomapi.LogScriptEvent("Microsoft.Dynamics.AX6.ManagementPack.AOS.Task.BatchFramework.RunningJobs", 100, 4, $eventBatchTaskRunnnigJobsStarted)

                

                $jobs = @{}

                try

                {

                    GetRunningJobs $dbServer $dbName $jobs

                    if($jobs.Count -gt 0)

                    {

                        $jobs.Keys | foreach {

                        $job = @{}

                        $job = $jobs.Item($_)

                

                        $jobObject = New-Object PSObject

                        $jobObject | Add-Member Noteproperty $localizedMessages.taskColumnJobId $job[$JobRecIdAttrib]

                        $jobObject | Add-Member Noteproperty $localizedMessages.taskColumnActualStartTime $job[$JobStartDateTimeAttrib]

                        $jobObject | Add-Member Noteproperty $localizedMessages.taskColumnEndTime $job[$JobEndDateTimeAttrib]

                        $jobObject | Add-Member Noteproperty $localizedMessages.taskColumnCreatedBy $job[$JobCreatedByAttrib]

                        $jobObject | Add-Member Noteproperty $localizedMessages.taskColumnCompany $job[$JobCompanyAttrib]

                        $jobObject | Add-Member Noteproperty $localizedMessages.taskColumnJobDescription $job[$JobCaptionAttrib]

                        

                        Write $jobObject

                        } | Format-Table -AutoSize

                    }

                    else

                    {

                        Write-Host $localizedMessages.noJobs

                    }                

                }

                catch

                {

                    WriteErrorToEventLog "GetRunningJobs"

                    Write-Host $localizedMessages.taskCompletionError

                }

            }      

            catch

            {

                WriteErrorToEventLog "GetLibraryPath"                

                Write-Host $localizedMessages.taskCompletionError

                return

            }



	  </Script></Contents>

        <Unicode>true</Unicode>

      </File>

    </Files>

  </WriteAction>

</Task>