• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 49
  • Last Modified:

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.bat\ 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);
0
Jasmine Sandlas
Asked:
Jasmine Sandlas
  • 2
1 Solution
 
Jasmine SandlasAuthor Commented:
I got the answer
0
 
Jasmine SandlasAuthor Commented:
I searched and got it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now