Post reply

Error when configuring SQL job step to execute powershell script

  • December 8, 2010 at 9:14 am

    #1260159

    Do you get an error if you set it up as a CmdExec jobstep that executes

    powershell c:\myfilepath\script.ps1

    Well, obviouslyyou won't get an error while creating the job step in this scenario, but when you run it I mean!

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • December 8, 2010 at 9:51 am

    #1260189

    It turned out the ps1 file was readonly; as soon as I made it read-write, issue was fixed.

    Silly eh? 🙂

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • December 8, 2010 at 9:53 am

    #1260191

    Ah, they're the best kind of issues 🙂

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply