Home / server / Questions / 269013
Accepted
simon
Asked: 2011-05-13 05:15:58 +0800 CST

MSSQL2005: is there a sproc to set the default distribution agent profile?

  • 772

I'm trying to work out how to set the default profile for the distribution agent programatically using t-sql. I see there is the sp_help_agent_profile and sp_help_agent_default sprocs which allow you to find out what the default is, but they don't allow you to set it.

Is there a sproc, or should I be directly updating the MSagent_profiles table?

sql-server-2005 tsql

1 Answers

  1. Best Answer

    Found it. You use something like:

    exec sp_MSupdate_agenttype_default @profile_id = 14

    where 14 is the id of the profile you want to set as default. I can't find any documentation for this sproc though, which is weird.

    • 0