Hi All,

Below is a typical code for getting result regarding SQL jobs

$srv.JobServer.Jobs | Where-Object {$_.IsEnabled -eq $TRUE} | Select Name,LastRunOutcome, LastRunDate

For sake of brevity I am not giving full code, in the above code srv is sql server.

What I need ?

I want to add a text before name of the job like- if job name is "Job - Truncate Table", i want it to be "MY - Job - Truncate Table". So I want to add "MY " before all job name. Please help.

Try this:

$srv.JobServer.Jobs | Select @{n="Name";e={"My {0}" -f $_.name}},LastRunOutcome, LastRunDate

Great! works absolutely fine.

 

Thanks a lot..