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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-10-24 : 14:10:36
|
| 2008 R2I have a job that gets fired somehow - not ny the Agent schedule.How can I determine where/what runs it?Thanks, Jack |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-10-24 : 14:48:43
|
| Run a trace. The job history should at least tell you the userid though.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-10-24 : 16:06:10
|
| The history does show the login that executed the job, yes. The job intentionally has no schedule but has ran a few times at varying hours and dates. No triggers exist so I'm a bit puzzled. What criteria would I need to select if I build a trace?Thanks, Jack |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-10-24 : 16:24:09
|
| To kickoff a job, you run sp_start_job. So SP:Completed in a trace should capture it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
What is Executing This Job?