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 |
|
matnyc2000
Starting Member
16 Posts |
 Posted - 2007-06-26 : 14:21:28
|
| hi,I have many jobs on sql 05 and all work but one. This one writes to an Access DB on the same server as SQL. The package works fine. But when executed in the context of the SQL Agent job, it fails. Jobs that write to a text file work fine. The Access DB has no password required. By the way, that job in sql 2000 worked fine.Any ideas? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-26 : 16:58:44
|
| Enable package logging so you can get details of why failure. |
 |
|
|
matnyc2000
Starting Member
16 Posts |
Posted - 2007-06-28 : 15:13:42
|
| I did enable logging. But I only get "the job failed". There's no additional info. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-28 : 22:51:39
|
| Enable logging and run the job again. |
|
|
|
LA768
Starting Member
9 Posts |
Posted - 2007-06-30 : 23:27:31
|
| This happened to me a few times where the package works fine and the job does not.All I had to do is to delete the job and recreate it. All worked fine from there.Larry :-) |
|
|
|
|
|
|
job doesn't work but package works fine