Find & Replace Text in Agents (Multiple Dbs)

We need to “find & replace” an external Db name (SQl Server) in agents that reside across multiple Dbs in the domain. Is there a way to do a single search that looks for “SQLA” and replaces with “SQLB” across all agents in databases on server A? I tried selected all agents in a single Db and cannot choose find & replace. The only option is opening the agent and using find & replace. Needless to say, this would take serious time. Honestly, we are not certain if other Dbs contain the reference. Thanks team… “find & replace” at the Db level would be nice.

Subject: Find & Replace Text in Agents (Multiple Dbs)

That is the province of third-party tools, such as TeamStudio Configurator.

Subject: RE: Find & Replace Text in Agents (Multiple Dbs)

Configurator is worth its weight in platinum…

Don’t forget the nifty (free) script helper tool they just put out.

  • Matt