You receive hundreds if not thousands of NT Authority\SYSTEM “Login failed for user ‘NT AUTHORITY\SYSTEM’. [CLIENT: <local machine>]” error messages
Errors often occur every minute
You’ve probably deleted your Shared Service Provider or created a new one. Unfortunately, some scheduled jobs will remain on your SQL server that reference the now defunct database.
Launch SQL Server Management Studio and connect to the server that houses your Shared Service Provider
Within SSMS expand the SQL Server Agent and select jobs.
Locate the jobs that have names that end in “_DeleteExpiredSessions”
You in the “Steps” tab double click on the first step and check to see if there’s a database, if there’s no database selected you’ve probably deleted said database so you can safely disable the job.
If you don’t understand these instructions or are confused then STOP! Disabling SQL jobs is dangerous business and can cause undesired outcomes.