• litu deb (2/23/2010)


    I need to know who has deleted the job?

    Unfortunately i don't think it is possible, Because when some delete job then an entry is also removed form sysjobs table. However if someone drops an object then it is possible to trace user name and object name if you install performance dashboard on your client machine, it will record all schema changes (only DDL changes not DML).

    EnjoY!

    EnjoY!