SQL 2005 Agent Configuration Problems

microsoft.public.sqlserver.tools

27 Apr 2006 1:10 PM

Aaron M. Lowe

Hello,

I've got two problems when attempting to set up SQL Server 2005 Agent. Any
help on either of these would be greatly appreciated.

1.) When I go into properties of SQL Server Agent and then to history. I
check the Automatically remove agent history checkbox and set the time
delay, but it doesn't stay checked when I exit and look again. Does anyone
know how to fix this or even better the specific registry key I can change
to force it? I believe it is in HKLM\Software\Microsoft\Microsoft SQL
Server\(Instance)\SQLServerAgent\

2.) On SQL Server Agent properties in General I have changed the location of
the log file so instead of D:\Program Files\Microsoft SQL
Server\MSSQL\LOG\SQLAGENT.OUT it is E:\SQLLogs\SQLAGENT.OUT However when I
go through Management Studio to view them it says "Unicode File Expected",
even though SQL Server is creating the files and automatically rolling them
over (I do have Write OEM error log and include execution trace messages
checked and am logging Errors, Warnings and Information).

Any help would be greatly appreciated.

Thanks,

Aaron Lowe