by RP » Sat, 31 Jan 2004 18:50:03
by Narayana Vyas Kondredd » Sat, 31 Jan 2004 19:17:10
I think it is possible using sp_start_job, but I cannot
get it to work. But, how can I get a job to start another
job on a different server, when it finishes? Can that be
done?
by James Hoke » Sun, 01 Feb 2004 06:52:30
As Narayana pointed out in the other response, you may do this via linked
server.
Be aware that sp_start_job just starts the job; it will not wait for its
execution to complete.
For that, you'd need to set up a primitive messaging architecture of some
kind, and poll for result.
James Hokes
Quote:> I think it is possible using sp_start_job, but I cannot
> get it to work. But, how can I get a job to start another
> job on a different server, when it finishes? Can that be
> done?
1. Remote Server -- Changing from Remote Server to Linked Server
I am trying to do queries from one server to another (both are running SQL
Server 2000 SP3) and get the error:
Server: Msg 18456, Level 14, State 1, Procedure xxxxxxxxx, Line 45
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
The only way it will work is if I am connected as SA. I have the servers
connecting as Remote Servers and realize that if they were set up as Linked
Servers then I could set up the permission between them. My problem is that
I can not drop them as a Remote Server in order to recreate them as Linked
Servers because I have replication set up between the servers and don't want
to go through the hassle of dropping and recreating replication.
I also have distributed queries going as a scheduled task with the owner of
the scheduled task as SA. These don't work with the same error in their log
files.
Is there some way to change the connection between the servers from Remote
Servers to Linked Servers without having to drop and recreate replication?
2. It's impossible to point SQL Server at an XML file!
3. How to start/stop a remote SQL server ?
4. How to know and change the owner of a table in psql ?
5. Starting Scripts on Remote Server
6. 'Generate SQL Scripts' makes deleted views appear.
7. cannot start/stop/pause on the remote sql server
8. tricky sql
9. MSDE (Jr. SQL Server 7.0) will not start on Win98 machine using SQLDMO from remote machine
10. How to programmatically start remote sql server?
12. JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS
13. Local job remote dts package fails with sql server not found