Setting Agent connection settings dynamically on SQL Server 7

Setting Agent connection settings dynamically on SQL Server 7

Post by Nabeel Zafar Mirz » Sat, 21 Jun 2003 07:48:55



On configuring a new server dynamically, I revoke the access through Windows
NT authentication. Now by default SQL Server Agent runs on Windows NT
authentication, and after restricting NT authentication, the Agent doesn't
start.

Is there a way to set the Agent connection properties dynamically (via TSQL
or SQL DMO object)? In enterprise manager such properties can be accessed on
the "Connection" tab of SQL Server Agent properties.

Regards,

NABEEL ZAFAR MIRZA

 
 
 

1. Help needed (Setting Agent connection settings dynamically on SQL Server 7)

On configuring a new server dynamically, I revoke the access through Windows
NT authentication. Now by default SQL Server Agent runs on Windows NT
authentication, and after restricting NT authentication, the Agent doesn't
start.

Is there a way to set the Agent connection properties dynamically (via TSQL
or SQL DMO object)? In enterprise manager such properties can be accessed on
the "Connection" tab of SQL Server Agent properties.

Regards,

NABEEL ZAFAR MIRZA
Senior Applications Analyst
Systems (Private) Limited

2. a good FMP PIM?

3. Question about dynamically setting DTS SQL connection information.

4. Truncate command says table trucnated but it is not, any ideas?

5. Dynamically setting connections and looping

6. CONNECTING TO INTERBASE

7. dynamically setting source and connection string.

8. BUG in SELECT SUM(<user-defined function>)

9. setting up SQL Server Agent mail

10. SQL Server Agent Job column length setting

11. Setting up a proxy account for SQL Server Agent

12. upgrading to 2000, no access to sql server agent setting

13. Setting Up SQL Mail for SQL Agent