Solved

SQLSERVERAGENT Warning

Posted on 2010-08-25
5
621 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

Suggested Solutions

Title # Comments Views Activity
OPINIONS please : best Active Directory Monitoring tool 5 135
Event ID: 1202 / Source: SceCli 6 106
Can’t delete a file 14 161
SQL Query with Sum and Detail rows 2 49
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now