Posts

Showing posts from April, 2013

How To Reassign a SQL Server Agent Operator

Neat trick in SQL Server 2005. If you need to reassign or replace a SQL Agent Operator, you can do so during the delete of the old operator. Like I had a bunch of stuff attached to a "ThisDBA" type operator and needed to reassign it to the "DBAGroup" operator. Here was the fastest path: Create your new Operator. Under "SQL Server Agent", "Properties", "Alert System": Change the "fail-safe operator" to your New Operator. Delete your Old Operator. Near the bottom of the Delete dialog screen is a "Reassign Operator" checkbox. Check that and choose your New Operator from the Popup. Click "Okay" twice and now your jobs and alerts are all attached to the New Operator. SWEET!