Run sql job on a remote server

[CuteDesiGal]

Remote access disabled so direct ga linkedserver thru run cheyalenu.

sp ayithe ila declare chesi running successfully but job ela chestham.

declare @runstoredprocsql varchar(1000);

set @runstoredprocsql = ‘exec dbname.dbo.sp’;

exec (@runstoredprocsql) at “remote server”;

print ‘proc executed’

[CuteDesiGal]

Ltt

[Gentle_Boy]

Were you able to add that remote server in your sql management studio...by any chance ? And then access it ?

[CuteDesiGal]

Yes i can but server a nunchi server b loni job kickoff cheyali

[Gentle_Boy]

2 minutes ago, CuteDesiGal said:

Yes i can but server a nunchi server b loni job kickoff cheyali

U can do that...keep trying ..

 

Google it

[CuteDesiGal]

Got it thanks