Tag Archives: sql agent

SQL Server Agent does not start | ‘(Unknown)’ is not a member of the SysAdmin role

Last week on one of the SQL Server 2000 instances, the SQL Server Agent service was not starting. This server was on the same domain in which the SQL Server Agent was connecting to SQL Server using sa login and … Continue reading

Posted in SQL Agent, SQLServerPedia Syndication, Troubleshoot | Tagged , , | 1 Comment

xp_sendmail: Procedure expects parameter @user, which was not supplied.

On one of the Production instances a job which sends the details of blocking sessions was failing. This is the same instance which was rebuilt on Tuesday. On checking the job history, it was found that the job was failing … Continue reading

Posted in services, SQL Agent, SQLServerPedia Syndication, Troubleshoot | Tagged , , , | 1 Comment