Re: delete job
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 05/27/03
- Next message: Mark Hibberd: "New owner with 'orig' owners permissions."
- Previous message: Jasper Smith: "Re: SP3 on MSDE"
- In reply to: Emsga: "delete job"
- Next in thread: emsga: "Re: delete job"
- Reply: emsga: "Re: delete job"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 27 May 2003 17:44:18 +0100
Your only real chance is to examine the transaction log for the msdb
database using Log Explorer from www.lumigent.com but since by
default msdb is set to simple recovery there's no guarentee the records
are still going to be there. But to answer the question, by default there
isn't any system table that would audit this.
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Emsga" <emsga@libero.it> wrote in message news:2f0301c32437$9e43f1c0$a401280a@phx.gbl... > Hi, > I have this problem: someone deleted a job on my SQL 7.0 > I'd like to find out when the delete occured and who > was the user (ip of the machine or user id where the > operation was done). > Exist a system/user table that contains this information? > The audit level on this SQL is none. > I hope this is possible and if someone tells me how it > would be really appreciated. > > Emilio > > > >
- Next message: Mark Hibberd: "New owner with 'orig' owners permissions."
- Previous message: Jasper Smith: "Re: SP3 on MSDE"
- In reply to: Emsga: "delete job"
- Next in thread: emsga: "Re: delete job"
- Reply: emsga: "Re: delete job"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
