SQLSERVERAGENT Warning

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.
newbiewebSr. Software EngineerAsked:
Who is Participating?
 
PHaddockConnect With a Mentor Commented:
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
 
newbiewebSr. Software EngineerAuthor Commented:
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
 
ThakurVinayConnect With a Mentor Commented:
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
 
Mohamed OsamaConnect With a Mentor Senior IT ConsultantCommented:
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
 
newbiewebSr. Software EngineerAuthor Commented:
Thanks.
0
All Courses

From novice to tech pro — start learning today.