Hi, We had disabled a job but windows event shows job failed error message in every 15 minutes. What is the problem? How can I avoid this error message? Thanks S. Ramesh
Run the profiler and see how it is being executed when it is disabled. There could be another job which is starting this failing job... Mohammed U.
Or even you can use SP_WHO2 to see what is triggering this process. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.