Start Job on Server B from Server A

[JohnBates]

hi everyone,

This is 2005.

I want to use sp_start_job to start a job on another 2005 server. I've setup linked servers both directions but still cannot start the job.

Is a master-->target configuration what i need?

Thanks, John

 

[calico]

HI,

Q: Is a master-->target configuration what i need?
A: may be it is what you need

calico

 

[SQLWilts]

What is the full code you are using?

you can configure one server to run multiple jobs on many other servers, but there are a lot of hoops to jump through if you only want to do this for one job...

What are you trying to do?

 

[JohnBates]

SQLWilts,

sp_start_job accepts a ServerName parameter. So I'm passing the name of the server that's been added as a linked server on the server the sp_start_job executes on.

But I'm at home today, not sure of the exact error message I received.

Yes I only need this for 1 job; sounds like you are referring to a master-->target configuration.

Thanks, John

 

[SQLWilts]

John,
I was indeed refering to a master-->target config. Its a bit over kill for your set up.

Stupid question - you aren't targeting a named instance and not putting the name in the server parm are you? Maybe on the target server see if there is anything weird in the network configuration setup. Also - the target server does accept remote connections, doesn't it?
Does the profile used via the linked servers have execute authhority over the SP the job is calling?
A few bit to check out

 

[JohnBates]

Thanks, SQLWilts.

Yes master-->target setup would be overkill. It's only for 1 job.

We'll find another way (or we just may not do it at all)

John