Got this when I ran my sp__updatestats procedure in a SQL Agent jobstep, but it worked in Query Analyzer. The reason? The default settings are probably different in QA rather than external connections similar to SQL Agent.

Msg 1934, Sev 16: UPDATE STATISTICS failed because the following SET options have incorrect settings: 'ARITHABORT'. [SQLSTATE 42000]

The solution was to recreate the procedure that ran UPDATE STATISTICS using a SET command within the procedure. 

CREATE PROCEDURE dbo.sp__UpdateStats
AS
SET ARITHABORT ON 
SET QUOTED_IDENTIFIER ON 
...

We started to get this problem after I added a computed column to a table. 

On SQL 2005 you have to tell SQL Server Agent / Properties / Alert System, which profile that you'd like to enable. Here's what it does.

e.g. and don't forget to restart SQL Agent.

USE [msdb]
GO
EXEC master.dbo.xp_instance_regwrite 
   N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent', 
   N'DatabaseMailProfile', 
   N'REG_SZ', 
   N'MyDatabaseProfile'
GO

I'm a little obtuse sometimes so when following the install instructions I didn't see where this was installed on my PC.

SQL Server 2005 Performance Dashboard Reports

So searching my entire PC here is the script that now needs to be run on each instance of SQL 2005 you want to monitor. 
      C :\Program Files\SQL Server DBA Dashboard

Here are some highlights from the script that may concern you.


CREATE ASSEMBLY DBA_Dashboard
FROM 'C:\Program Files\SQL Server DBA Dashboard\DBA_Dashboard.dll'
WITH PERMISSION_SET = SAFE

GO

and

Automatically add a schedule to a SQL Agent job. This example adds one that will run two hours from now, once. Left to do: what if no longer today?

More tokens.

DECLARE @vcSchedule VARCHAR(128),
   @nJOBID uniqueidentifier,
   @nDATE INT,
   @nTIME INT,
   @nHours INT
SELECT @vcSchedule = 'Reschedule',
   @nJOBID = CONVERT(uniqueidentifier, [JOBID]),
   @nDATE = [DATE],
   @nTIME = [TIME],
   @nHours = '020000' + @nTIME
--SELECT @nJOBID, @nDATE, @nTIME, @nHours 

IF EXISTS (SELECT [name] FROM [msdb].[dbo].[sysjobschedules] WHERE job_id = @nJOBID AND name= @vcSchedule)
  EXEC msdb..sp_delete_jobschedule @job_id=@nJOBID, @name=@vcSchedule

EXECUTE msdb.dbo.sp_add_jobschedule 
   @job_id = @nJOBID, 
   @name = @vcSchedule, @enabled = 1, 
   @freq_type = 1, 
   @active_start_date = @nDATE, 
   @active_start_time = @nHours, 
   @freq_interval = 1, --once
   @freq_subday_type = 1, --At the specified time
   @freq_subday_interval = 1, 
   @freq_relative_interval = 0, 
   @freq_recurrence_factor = 0, 
   @active_end_date = 99991231, 
   @active_end_time = 235959