• 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.