Job with TSQL script does nrt work 
Author Message
 Job with TSQL script does nrt work

I have Transact-SQL script with string:
EXECUTE ("INSERT INTO <Local Table> exec <Remote
Server>.master.dbo.sp_sqlexec 'select * From <Remote Database>.dbo.<Remote
Table>'")
Remote and Local servers (NT4+SQL7+SP2 ) is connecting over the Internet.
All work fine wia SQL Server Query Analyzer.
But when I make new Job in SQL server Agent with This script(owner-sa,Run as
user <self>) Job failed.
Remote Server has user sa, and Remote Server Properties <Map Remote Logins
to sa>.
Some Job with script using both local servers is working fine.
Can anyone help me ?
Thanks.
Yuriy.



Mon, 09 Jun 2003 16:52:29 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Job with TSQL script does not work

2. How can I script db from tsql script?

3. TSQL question - what am I doing wrong?

4. JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS

5. Script job to create scripts

6. Script size problem when executing an Active Script job

7. SQL-DMO (Active script within job step) Problems with Script statement

8. Batch TSQL Script with SQLDMO

9. running SQL script (TSQL) file in VB

10. Scripting transfers in TSQL (6.5)

11. SQL script that works in 7.0 not working in 2000

12. Scripting DB Objects using TSQL


 
Powered by phpBB® Forum Software