DeleteExpiredSessions Job on SQL

Posted on 2008-11-06
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
    LVL 51

    Expert Comment

    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

    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

    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

    Thanks for this

    Author Closing Comment

    Thanks for this, we looked around and got it fixed

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    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…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 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

    15 Experts available now in Live!

    Get 1:1 Help Now