Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQLSERVERAGENT Warning

Posted on 2010-08-25
5
625 Views
Last Modified: 2013-11-25
I removed TFS form my server today and detached al databased starting with ""Tfs" as in 'TfsWorkItemTracking".

Now I am getting the following warning.

Any ideas how to stop it?


SQL Server Scheduled Job 'TfsWorkItemTracking Process Identities Job' (0x9FA3161E221C494495DE7C44542C5FC7) - Status: Failed - Invoked on: 2010-08-25 20:40:00 - Message: The job failed.  The Job was invoked by Schedule 3 (ProcessIdentitiesSchedule).  The last step to run was step 1 (Process Identities).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
Comment
Question by:newbieweb
5 Comments
 

Author Comment

by:newbieweb
ID: 33527362
That warning happened at the asame instant as this

Failure Audit:

Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
 
LVL 3

Accepted Solution

by:
PHaddock earned 300 total points
ID: 33528486
Open SQL Server Management Studio and connect to the server.
Expand the SQL Server Agent
Expand Jobs.
You'll probably find the backup task in there and will be able to remove it.
0
 
LVL 5

Assisted Solution

by:ThakurVinay
ThakurVinay earned 100 total points
ID: 33528711
your "'TfsWorkItemTracking Process Identities Job' " is failing which is pointing to the dataabase you have detached. you can desable or delete that job.

HTH
Vinay

0
 
LVL 23

Assisted Solution

by:Admin3k
Admin3k earned 100 total points
ID: 33534400
You will find around seven SQL server jobs related to TFS under SQL server Agent,all should begin with TFS , if SQL server is no longer needed on this server you can uninstall it, if you do need SQL just delete all the jobs under SQL server agent that match this criteria.
0
 

Author Closing Comment

by:newbieweb
ID: 33546151
Thanks.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question