November 27, 2007 at 3:05 am
I am running a 2005 instance. The SQL Service Startup and SQL Server Agent accounts are domain accounts with SQL SysAdmin rights.
When I build a Maintenance Plan and run a job it fails. If I manually create a job and run it all is well.
All the log contains is:
Message
SQL Server Scheduled Job 'MaintenancePlan.Subplan_1' (0x4AB34EC85D1152409A2CA0EAA9AB5E06) - Status: Failed - Invoked on: 2007-11-27 10:00:40 - Message: The job failed. The Job was invoked by User COMPUTING\Steve_Hindle. The last step to run was step 1 (Subplan_1).
I have the same setup on another server and it works fine.
Any ideas as I'm stumped!
PS. Selecting the SysAdmin Server Role against a login means all other Server roles are covered by definition?
Regards
Steve
November 27, 2007 at 6:57 am
Check the logfile for the maintenance plan. At least I hope you configured logging.
The logfile should give you more details about the problem. The default path is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
[font="Verdana"]Markus Bohse[/font]
November 27, 2007 at 7:02 am
Yes I always configure logging. That's where I got the message from I included in the first post.
Since I posted I have discovered that the SQL box that is working has SP2. The one that isn't has no SP! I'm hoping when I SP2 it the plan will work.
Regatrds
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply