SQL Server Performance

Windows Event Log Error

Discussion in 'General DBA Questions' started by sramesh, Dec 28, 2006.

  1. sramesh New Member

    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?

    S. Ramesh
  2. MohammedU New Member

    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.
  3. satya Moderator

    Or even you can use SP_WHO2 to see what is triggering this process.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page