0

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?

simon
  • 714
  • 1
  • 7
  • 21

1 Answers1

0

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.

simon
  • 714
  • 1
  • 7
  • 21