Solved

SQLSERVERAGENT Warning

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Upgrading SQL 2005 Express to 2008 R2 Express 31 68
SQL 2005 - Memory Table Column Names 11 68
Shadow copies windows server 2003 2 79
AD user acount change history 4 64
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
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.
This is an introductory video for CloudBerry Managed Backup. You will learn how to sign up with the service and get started in a few minutes.
Send secure, cloud-based, encrypted alerts and maintain HIPAA compliant messaging. Integrates priority & secure messaging into one application. Ensures IT, emergency respondents and healthcare professionals that their critical messages are never mis…

911 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

20 Experts available now in Live!

Get 1:1 Help Now