Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Multi-Server jobs - XP Agents

Discussion in 'SQL Server 2008 General Discussion' started by Peter Schmitz, Oct 1, 2012.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    I'm still in the middle or adding servers to a multi-configuration setup, and other than the error I ran into earlier, requiring EXECUTE permissions on sp_ssis_getfolder, I enocuntered another error today:

    To enable this option, on the target server, the 'Agent XPs' option has to be turned on. This is easily done:

    Code (TSQL):

    sp_configure 'Agent XPs', 1
    RECONFIGURE
     
    You can also visually see whether the option is on or off, by the way, as SQL Server Agent will then show it in its description:

    Agent XPs.png
  2. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Attempting to change the setting as described above might not be possible on your system off the bat if you did not turn on the ability to show advanced options.If this is the case, you will see the following error:

    Luckily, this, too, is easily done by issuing the command below:

    Code (TSQL):

    sp_configure 'show advanced options', 1;
    RECONFIGURE;
     

Share This Page

Sponsored link: