DSXchange

How to call sql serveragent job from datastage?

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?".

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

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.

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

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

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

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.

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

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