April 5, 2008 at 4:08 am
I have two servers which one is SQL Server 2005 and the othe one is Oracle 10g.
A linke servre is stablished between these tow systems , ofcourse the linked server is defined at SQL 2005 side for one of SQL local logins.
There is an SP which must run at the SQL side , and its duty is updating a table in SQL by using a table in Oracle side.
When the valid user ( in linked server ) runs this SP , it runs succesfully. But when this SP is scheduled as a job , it failed to run.
All the SQL agents' Log on Account is a local account in the windows like USERA. And because USERA is not permitted to use the linked servre , when the job attemp to run with USERA, it fails.
It must be mentioned that USERA must not be added to linekd server for the security reasons.
Is there any way to schedule this SP tha could be run?
April 5, 2008 at 9:26 pm
DUPLICATE POST.................
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply