Jasmine Sandlas
asked on
Can I run the informatica workflow which happened to be in another server, from my SQL agent job which happen to be in different server?
Can I run the informatica workflow which happened to be in BI14 server, from my SQL agent job which happen to be in BI13 server?
Please help experts!
Running below code:- But got access is denied.
declare @result int;
declare @cmd as varchar(1000);
set @cmd = '\\BI14::PATH:\AB\CD\EF.ba t\ Folder_Name Workflow Name';
create table #output (id int identity(1,1), output nvarchar(255) null)
insert #output (output) EXEC @result = xp_cmdshell @cmd
select @result = count(1) from #output where output like '%successfully%';
--drop table #output
IF (@result = 0) RAISERROR (50001, -1, -1);
Please help experts!
Running below code:- But got access is denied.
declare @result int;
declare @cmd as varchar(1000);
set @cmd = '\\BI14::PATH:\AB\CD\EF.ba
create table #output (id int identity(1,1), output nvarchar(255) null)
insert #output (output) EXEC @result = xp_cmdshell @cmd
select @result = count(1) from #output where output like '%successfully%';
--drop table #output
IF (@result = 0) RAISERROR (50001, -1, -1);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER