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 |
|
matthew00
Starting Member
10 Posts |
 Posted - 2006-11-29 : 16:31:48
|
| Does anyone know how to trace and find out why couple jobs disappeared all the sudden? Is there any kind of auditing to trace down what's going on?thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-29 : 16:45:28
|
| Are you using SQL 2000 or SQL 2005?Has something happened to your system database (master, msdb, model) ?Peter LarssonHelsingborg, Sweden |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-29 : 16:49:23
|
jobs are stored in msdb. the normal way to delete them is with calls to msdb.dbo.sp_delete_jobif you have any idea when this occured, you could take a look at agent's log file to see if anything bad happened. it's in a file called SQLAGENT.OUT, in a location like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG.the logfile gets renamed to SQLAGENT.1,2,3,4 each time you restart agent, so you might see a few there. OUT is the current one.
SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
http://www.elsasoft.org |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-11-29 : 21:46:32
|
| I don't think deleting a job will write out to a log file tho.... |
|
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2006-11-30 : 13:44:54
|
| If the job was RUNNING when it was deleted an error message will be written to the SQL Agent log... |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-11-30 : 15:18:41
|
| Another possiblity is someone changed the owner of the job. A non-sa user won't necessarily be able to see other user's jobs.Be One with the OptimizerTG |
|
|
|
|
|
|
|
|
Jobs Disappeared