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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Daniel_PLDB 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
yostnetAuthor Commented:
thx for the help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.