Post reply

Scripting SQL Agents Jobs using Powershell

  • April 9, 2013 at 12:17 am

    #276252

    Comments posted to this topic are about the item Scripting SQL Agents Jobs using Powershell

  • April 9, 2013 at 6:57 am

    #1604787

    Nice script.

    To get it to run properly I had to comment out lines 9, 13, 39 and 40. /* and */ are not valid in powershell. Lines 39 and 40 probably should have been outside the code tags.

    Also the variable $TypeFolder is never set to a value. What was your intentions for it?

    Bill Soranno
    MCP, MCTS, MCITP DBA
    Database Administrator
    Winona State University
    Maxwell 143

    "Quality, like Success, is a Journey, not a Destination" - William Soranno '92

  • February 4, 2015 at 11:27 am

    #1775429

    Works very well for just jobs. However, if that job is tied to a Maintenance plan it generates the job part but is worthless without the maintenance plan.

  • April 27, 2016 at 1:49 pm

    #1875064

    Thanks for the script.

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

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