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 |
|
wendy
Starting Member
19 Posts |
 Posted - 2005-06-28 : 11:19:32
|
| I have a scheduled SQL job which run query across linked server failed, and I am thinking is the right issue for SQL agent service. Does anyone have the experience for setup the job run across linked server?ThanksWendy |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-28 : 11:42:38
|
| When you right click on the job in the EM and choose View Job History and on the resulting screen, choose show step details, What is the error message on the bottom part of the screen for the job that failed?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-28 : 22:40:25
|
| Does the user who owns the job or is specified as login in the linked server (depending on how you setup the linked server) have permissions on the tables of the other server?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-06-28 : 23:31:03
|
| do you really need to use linked server or is DTS an alternative?anyways, you probably need to map the job owner to a remote login in your linked server, remember that linked server uses standard logins--------------------keeping it simple... |
|
|
|
|
|
|
setup the job run across linked server