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 |
|
manijash
Starting Member
8 Posts |
 Posted - 2009-01-07 : 05:34:46
|
| When I execute the job immediate it is working fine. when I schedule the job it was throwing error. The job failed. The Job was invoked by User data_value3_user. The last step to run was step 1 (DTS_job).how to resolve this |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-07 : 06:23:02
|
Do the user "owning" the current job has enough privileges to do the work?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
manijash
Starting Member
8 Posts |
Posted - 2009-01-07 : 06:31:20
|
| When I schedule immediate it was working fine, But the problem is while scheduling the job |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-07 : 06:49:12
|
Yes. The scheduled code is run under another context, the context of which the user is set to "own" the job.Does that user have same rights as you to access the table(s)?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Job Failed