SQL 208 Error on BACKUP/MAINT PLAN

trying to d a simple maintenance plan | Getting an error stating that it can validate the user.

SQL Server Scheduled Job 'CREDIT.Subplan_1' (0x69F75C1D5DB95C4D8F0A695C189979E2) - Status: Failed - Invoked on: 2011-03-31 06:15:17 - Message: The job failed.  Unable to determine if the owner (WSB\cq) of job CREDIT.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'WSB\cq', error code 0x5. [SQLSTATE 42000] (Error 15404)).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
yostnetAsked:
Who is Participating?
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
Connect to SQL Server click new query paste code above and click execute.
Or
Connect to SQL Server, in Object Explorer open SQL Server Agent. Next open Jobs then right click on CREDIT.Subplan_1 job and click properties. Click on ... button and in new windows click browse, choose apropriate login (sa in this case) click ok, and again choose login and click ok. In main job properties click ok.
0
 
Daniel_PLDB Expert/ArchitectCommented:
Change CREDIT.Subplan_1 job ownership to e.g. SA login either in SSMS or by T-SQL:
 
USE [msdb]
GO
EXEC msdb.dbo.sp_update_job @job_name=N'CREDIT.Subplan_1', 
		@owner_login_name=N'sa'
GO

Open in new window

0
 
yostnetAuthor Commented:
Where at in SSMS can I do this?
0
 
yostnetAuthor Commented:
thx for the help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.