Home Forums SQL Server 2005 Administering Who created the job? RE: Who created the job?

  • February 14, 2011 at 2:45 pm

    #1286758

    Grant Fritchey (2/14/2011)

    For a) you want to take a look at the default trace. That's how you can tell who made structural changes to the system.

    As far as b) goes, if the user is still there, the jobs are running under that security context since that user is the owner. I don't know what would happen if you deleted the user. I suspect the job would fail.

    Thanks Grant

    a) Doesn't really help because gives data from default trace about few days back. I was expecting to query a table to find " who created" sql job.