[Last Call] Learn how to a build a cloud-first strategyRegister Now


DeleteExpiredSessions Job on SQL

Posted on 2008-11-06
Medium Priority
Last Modified: 2010-04-21

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.
Question by:hctdwc
  • 3
  • 2
LVL 51

Expert Comment

by:Ted Bouskill
ID: 22902038
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.

Author Comment

ID: 22902514
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
LVL 51

Accepted Solution

Ted Bouskill earned 375 total points
ID: 22907084
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)

Author Comment

ID: 23323533
Thanks for this

Author Closing Comment

ID: 31513847
Thanks for this, we looked around and got it fixed

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

831 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