• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2864
  • Last Modified:

DeleteExpiredSessions Job on SQL

Hi,

I am seeing this error logs on SQL. DeleteExpiredSessions failed. But when i checked there is no jobs on the SQL Server. There was an installation of Sharepoint 2007 eralier and may be we had a job, but now it is not there and the message is still popping up.
0
hctdwc
Asked:
hctdwc
  • 3
  • 2
1 Solution
 
Ted BouskillSenior Software DeveloperCommented:
When Sharepoint is uninstalled or when you drop and recreate a Shared Service Provider it leaves behind a timed job to delete expired sessions.  The job must be there otherwise you wouldn't be getting these errors.
0
 
hctdwcAuthor Commented:
When i look under Microsoft SQL Agent, and under jobs, i dont find any jobs. we think as you mentioned when the admin dropped and recreated SSP it was lost, but can see any trace of that. can i remove it using codes etc..  Helppppppppp
0
 
Ted BouskillSenior Software DeveloperCommented:
If you installed Sharepoint as a standalone installation it would have installed another instance of SQL as the embedded version.  It's a special version specifically for Sharepoint.  Search your server for other instances of SQL (I can't remember the funky name it uses)
0
 
hctdwcAuthor Commented:
Thanks for this
0
 
hctdwcAuthor Commented:
Thanks for this, we looked around and got it fixed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now