sql server agent job clarifications

vamsi_4a6 · Post by **vamsi_4a6** » Fri Mar 18, 2016 8:54 am

How to call sql serveragent job from datastage?

chulett · Post by **chulett** » Fri Mar 18, 2016 9:04 am

The first question in my mind will always be "how would you do X outside of DataStage?" - that should give you a good head start on the how of from / inside DataStage.

Now I don't do SQL Server but seeing as how it is Windows only then in my mind the question would be "how to call sql serveragent job from a UNIX server?".

vamsi_4a6 · Post by **vamsi_4a6** » Fri Mar 18, 2016 10:03 am

I can create batch script to run sql server agent Job.That batch script is on my local system.My datastage server is different environment not sure how to call batch script since datastage will not recognize my local system file

chulett · Post by **chulett** » Fri Mar 18, 2016 11:32 am

That's the thing, you can't. To go that route you'd need a script on the UNIX server that would remotely access the SS database and invoke the job. That or perhaps your company could buy / install UNIX ODBC drivers for SQL Server on the DataStage server and then trigger it through a job or script.

Others may chime in if they've had to do something like this. As noted, I haven't, so am just making educated guesses on what your options are.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 18, 2016 2:48 pm

An ODBC driver (on UNIX) for SQL Server ships with DataStage. It's OEM from Data Direct.

chulett · Post by **chulett** » Fri Mar 18, 2016 4:24 pm

Good to know... any idea as of what version?

ray.wurlod · Post by **ray.wurlod** » Sun Mar 20, 2016 2:07 am

All versions of DataStage. The Data Direct drivers have their own versioning.

chulett · Post by **chulett** » Sun Mar 20, 2016 7:42 am

Ok... did you miss the "as of" part? I don't recall any of the UNIX versions I worked with (pre-9.x) shipping with SQL Server drivers, hence the question as to when 'they' started including them. Or maybe they always did and I just never needed to use them.

ray.wurlod · Post by **ray.wurlod** » Sun Mar 20, 2016 11:58 am

Well, certainly in 8.5, the oldest version to which I currently have access.

chulett · Post by **chulett** » Sun Mar 20, 2016 6:07 pm

Okie dokie, thanks for the clarification. So disregard the 'buy/install' statement earlier and replace it with 'leverage'.