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.
hctdwcAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hctdwcAuthor Commented:
Thanks for this
0
hctdwcAuthor Commented:
Thanks for this, we looked around and got it fixed
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.