Hello,I am trying to set up a couple maintenance jobs in my sql 2005 server, however Im getting some errors.I have a simple maintenance plan that is deleting .bak files older than 3 daysEXECUTE master.dbo.xp_delete_file 0,N'D:\DB BU',N'bak',N'2011-10-29T15:59:02',1
however when im running it i get the following error in the View History of the job subplan:The job failed. Unable to determine if the owner [XXXXX\Administrator] of job MaintenencePlan.SubPlan_1 has server access [reason: Could not obtain information about Windows NT group/user XXXXX\Administrator',error code 0x534. [SQL State 42000] [Error 15404].Im using the Windows Authentication login to log into SQL Server Manager, which has sysadmin priveleges.Any thoughts on what I might be doing wrong would be appreciated.Thanks!
Help with Server Agent Job Execution
Posted - 2011-11-01 : 17:05:44
