Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-03-05 : 10:19:49
|
| Is there anyway(trigger) so nobody can delete the jobs in SQL Server?Actually we have 4 people who has SYSADMIN rights in that server and just wanna track out.No information is recorded in error logs and application log. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-05 : 10:33:58
|
| I suppose you could put a trigger on sysjobs. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-05 : 11:31:14
|
| But how? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 22:39:20
|
| Or read msdb's log with third party tools like Lumigent's Log Explorer. |
|
|
|
SusanthaB
Starting Member
14 Posts |
Posted - 2008-03-06 : 05:14:02
|
| Set up the profiler for the server which you need to audit job deletions.Events to be used.1. SQL: BatchCompleted2. RPC: Completed3. SP: CompletedColumns to be used1. TextData2. DatabaseID3. SPIDFilters to be used in TextData column. 1. Like %sp_delete_job%2. Like %sysjobs_view%You have the flexibility of modifying these changes according to the requirement.Eg: You can set filters to captures only selected logins. Susantha BathigeSenior DBA, Sri Lanka |
|
|
|
|
|
|
About jobs.