Browse by Tags
All Tags »
sqlagent (RSS)
When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL Server
Read More...
A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application
Read More...
Within your SQL Server environment many times you might have observed sp_sqlagent_get_perf_counters running within the Profiler trace, sometimes they may result in high CPU conditions. They are demo alerts to test whether the alerts are working within
Read More...
Interesting post in MSDN forums on the error: SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'mydomain\myusername', error code 0x54b. [SQLSTATE 42000]
Read More...
Can we change the location of SQL agent error log file after the SQL Server program is installed? Yes, i n terms of configuring a specified number of SQL Server Agent error logs, this is not possible. The default number of log files for SQLAGent is 9
Read More...
Since the days of SQL 70 automated administrative tasks are getting better with the usage of SQLAgent, you need to know how to configure alerts and set up operators, the people SQL Server contacts when alert conditions arise. SQLAgent Jobs can trigger
Read More...