Home Forums SQL Server 2008 SQL Server 2008 Administration Call powershell in SQL agent job RE: Call powershell in SQL agent job

  • April 1, 2013 at 3:48 pm

    #1602624

    sqlfriends (4/1/2013)

    Grant Fritchey (4/1/2013)

    Glad to hear it's fixed.

    Just curious though, why not use a PowerShell type of step in SQL Agent for a PowerShell script?

    I found it runs much faster using cmdexe type vs powshell type to run the jobs.

    I read an article telling what is the difference , it seems they are using different powershell module to run the job. I cannot find the article now by doing some search.

    For my cases, I can use both, but it takes much shorter time for using cmdexec to trigger the job and finish the job.

    🙂

    Shifting gears, do you have any auditing in place to audit your PowerShell runs at the OS Level? Has nothing to do with your current problem. I'm just curious. Thanks for any feedback on this.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)