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 |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2008-01-23 : 18:19:52
|
| Greetings,If you set up a job, be it with a script or with DTS, and the job fails, does it have any type of negative impact on the system if you don't fix it or disable it?I know this a a bit elementary but please let me know.thx |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-23 : 18:34:24
|
| It depends on what the job was doing and if there is any dependency of any functionality on the success/failure of the job.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-01-23 : 18:51:21
|
| Thanks a lot for your prompt response.The job was supposed to extract data from sql db to Access db.However, there are a couple of other databases running on this sql.Those databases are not mine but I didn't think this was affecting them but I wanted to ask you experts so I can be sure.Thanks again |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-23 : 19:32:02
|
| from your description the only folks being affected seem to be the ones using the Access db.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-01-23 : 19:58:20
|
| Thank you so very much.I have had situations where someone is allowed to set up jobs to run on their databases even I am the owner of the sql box and I see these failed job errors but they don't impact my db negatively and so I didn't bother but not sure why I am getting "warnings" from these guys to fix it or disable it.Thanks very much again. |
|
|
|
|
|
|
Failed jobs