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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2006-03-16 : 17:14:53
|
| I want to have jobs that run CHECKDB (instead of using the Maintenance Plans). If the CheckDB finds an error, will it make the job show as "Failed". (We have people who check all jobs each morning and having it fail would be ideal if there were problems).Any thoughts in how to better run this on a schedule and get notified?________________________________________________The only cure for thinking is picking rocks, or drinking beer. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-16 : 17:19:49
|
| Yes it will show the job as failed if it has errors.Tara Kizeraka tduggan |
 |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-03-16 : 18:32:44
|
quote:
Originally posted by tkizer
Yes it will show the job as failed if it has errors.Tara Kizeraka tduggan
Thank you young lady________________________________________________The only cure for thinking is picking rocks, or drinking beer. |
|
|
|
|
|
|
CheckDB Job