Get SQL Agent Job stepID

This topic contains 4 replies, has 2 voices, and was last updated by  M. Chalut 1 year, 1 month ago.

  • Author
    Posts
  • #49733

    M. Chalut
    Participant

    Hi again guys!!!

    Now this time I would like to get the SQL Agent Job stepID from powershell. I only have the StepName and I would like to get information from the Job History as follow:

    write-host "Name: $($job.JobSteps[$stepID].Name) RunDate: $($job.JobSteps[$stepID].LastRunDate) Status: $($job.JobSteps[$stepID].LastRunOutCome)"

    Can I get this information using the stepname?

  • #49737

    Don Jones
    Keymaster

    It looks like $stepID contains the step ID, doesn't it?

  • #49743

    M. Chalut
    Participant

    Well... I have to get it somehow!!
    I have this working...
    Example:
    write-host "Name: $($job.JobSteps[1].Name) RunDate: $($job.JobSteps[1].LastRunDate) Status: $($job.JobSteps[1].LastRunOutCome)"

    However, in my program, the user is entering the StepName only. I tried the following:
    $stepID = $job.CurrentRunStep
    write-host "StepID = $steID"

    But it gives me the following:
    StepID = 0 (unknown)

  • #49745

    Don Jones
    Keymaster

    You'd have to query that from SQL Server. Sorry, I thought you had $stepID. I'm not sure how you'd query that – it's really a SQL Server question, not PowerShell. Again, sorry.

  • #50603

    M. Chalut
    Participant

    I found it!!
    $JobStep = $Job.JobSteps[$StepName]
    Write-Host "Name: $($JobStep.Name) RunDate: $($JobStep.LastRunDate) Status: $($JobStep.LastRunOutCome)"

You must be logged in to reply to this topic.