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 |
|
Sha
Starting Member
1 Post |
 Posted - 2006-01-16 : 12:32:28
|
| Hi!!I´m having a problem setting up a job in sql.When i run my DTS is on succed but when I schedule the job --failed Is connecting a sql serve db with msaccess you.Sombody know? if i have to consider something?? |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-16 : 13:16:27
|
| what error are you receiving when you schedule your job? Right click on the job, select view job hisory. Check the checkbox Show Step Details and when you click on the step that failed what error message it is displaying? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-16 : 13:21:56
|
| Log into the database server using the MSSQLSERVER service account. Run the DTS package from there via Enterprise Manager. This will mimick what the job is doing. Post the error here.This problem is most likely due to the DTS package needing to get to an outside resource such as a file or drive that doesn't exist from the database server's perspective or the MSSQLSERVER service account doesn't have permissions to it.Tara Kizeraka tduggan |
|
|
|
|
|
|
SQL jobs and MSACCESS