PrepAway - Latest Free Exam Questions & Answers

Tag: SQL Server Agent cannot run stored procedures

Which SQL Server Agent system stored procedure should you use?

You are the SQL administrator of your company. The network contains 10 SQL Server 2008 computers. Allservers are members of a group named Corporate SQL Servers . You are in the process of creating an operator for a master SQL Server Agent. You run the sp_add_operator system stored procedure to configure the master SQL Server Agent operator on a new server named SQL1 . Now,you want to add SQL1 to the Corporate SQL Servers group. Which SQL Server Agent system stored procedure should you use?