I am accessing a TurboImage database (ISAM Files) from a remote HP3000 miniframe using ODBC32.
I have a stored procedure named getClasses that takes a single varchar parameter.
The procedure works in Query Analyzer and performs the 2 openquery operations and update three local tables.
However, my goal is to automate this andf run it every 15 minutes or so.
I set up the job to run the query getClasses "A233" but the job fails to run. I get a couple different errors in the job history after changing users.
Executed as user: download. Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.
This seems to be the most prevalent. I was running as the server, but the server account is not mappable to the remote server. The username and password for the HP3000 is setup in the ODBC connection. As such is not provided in the security tab of the remote servers.
To work around the problem, you may:
1. Change the job owner to SA.
2. Try to edit the job step that executes the Stored Procedure from TSQL to
----In the Edit Job step dialog box, general tab, change the type from TSQL to Operating System Command
----Change the command to osql -E -Q"exec StoredProc"