SQL Jobs

  • Hello,

    Is it possible in SQL Server 2005 Standard Edition SP1 to see who disable a SQL job?

    (C2 Audit is disable and must be disable for performance reasons)

    Thank you.

    G.

  • Not that I know of. Not unless you had a trace running that would show that information or there was a trigger on the msdb.dbo.sysjobs table that recorded who made the change.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • I had no trace on...

    G.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply