Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

information of deleted job Expand / Collapse
Author
Message
Posted Tuesday, February 23, 2010 2:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, March 7, 2010 11:38 PM
Points: 46, Visits: 266
If anyone delete some sql jobs..Is there any way to get information about that.
Post #870978
Posted Tuesday, February 23, 2010 2:13 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 3:32 AM
Points: 1,904, Visits: 2,845
You could prevent it by defining the permissions on specific accounts.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #870985
Posted Tuesday, February 23, 2010 2:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 1, 2011 3:57 AM
Points: 29, Visits: 171
Hi,

What information do you want

1) Who deleted the job
or
2) The job scripts

If you want the job scripts
You should have the backup of MSDB database. U can restore it and get the job details back.
Post #870993
Posted Tuesday, February 23, 2010 4:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
you can get those information from the backup of msdb database. But restore msdb into test environment and get the required information.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #871023
Posted Tuesday, February 23, 2010 7:19 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, March 7, 2010 11:38 PM
Points: 46, Visits: 266
I need to know who has deleted the job?
Post #871627
Posted Tuesday, February 23, 2010 10:44 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 20, 2013 9:25 AM
Points: 389, Visits: 357
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!
Post #871695
Posted Tuesday, February 23, 2010 10:55 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 3:32 AM
Points: 1,904, Visits: 2,845
Agreed.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #871703
Posted Thursday, February 25, 2010 4:13 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 3,125, Visits: 5,937
When you drop the job you use procedure sp_delete_job.
So you might need to query some of the DMVs when and by whom that proc was used the last time.



Post #873083
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse