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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-29 : 11:29:53
|
| Dayve Harris writes "I am having a problem with executing jobs on SQL Server. I can successfully use linked servers and query/insert data when using the Query Analyzer but when creating a job it consistently fails when I try to run it manually or schedule it. I have also experienced the same problem with creating a DTS Import. The DTS package will run, but when I create a job for it, it fails. It seems to me that any job I create is failing. I have tried other servers using the exact same process and it works. What could I have done to my server to prevent jobs from running? Thanks for any help or assistance you can point me to.Dayve" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-29 : 12:18:24
|
| Jobs run under the SQLSERVERAGENT service account. Do you have that setup with Local System Account? Are your jobs referring to paths that are not valid on the database server? What error do you get from the jobs?Tara |
 |
|
|
|
|
|
Problem with SQL Jobs