Linked Server : Jobs Failing

Hi,
when i run the following st using linked server its working fine but when sa
me pasted in job and created a job on server A the job failed giving the bel
ow error message..
error :
servera$'. [SQLSTATE 28000] (Error 18456). The step failed.
sql st from server A where linked server has been created with server B)
exec server b.northwind.dbo.temp1
i have used 'useself' as the security option and set other options as defaul
t.
both the server are supporting named pipes protocol..!!!
pls help
--
SanjayHi
If the error message includes the account with which you are trying to acces
s the server, you do not have permission to log in to the server.
Verify the job owner permissions on the linked server, or change the job own
er.
Jakus Andras MCDBA
"Sanjay" wrote:

> Hi,
> when i run the following st using linked server its working fine but when
same pasted in job and created a job on server A the job failed giving the b
elow error message..
> error :
> servera$'. [SQLSTATE 28000] (Error 18456). The step failed.
> sql st from server A where linked server has been created with server B)
> exec server b.northwind.dbo.temp1
> --
> i have used 'useself' as the security option and set other options as defa
ult.
> both the server are supporting named pipes protocol..!!!
> pls help
> --
> Sanjay