Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Who am I ?

    Finally I use 2 tokens.

    But I'm not sure it is the best solution.

    $myRes = Invoke-Sqlcmd -Query "Select job_id, name From msdb.dbo.sysjobs Where job_id = Convert(Uniqueidentifier,$(ESCAPE_NONE(JOBID)))"

    $myJobName = $myRes.name

    $myRes = Invoke-Sqlcmd -Query...

Viewing post 1 (of 2 total)