Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Waymire Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent RE: Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent

  • January 3, 2012 at 9:19 am

    #1427801

    Agree and disagree: 🙂 🙁

    "repetitive tasks, or as in the case of CmdExec, any task that leaves the SQL Server environment is much simpler from the PowerShell subsystem.

    Disagree:

    Any repetitive SQL Server task can be easily done using t-sql inside SQL Server - that's what you have SQL Server Agent for!

    Agree:

    Tasks that leave the SQL Server environment - here PowerShell might be worth exploring.