sql server agent job clarifications
Moderators: chulett, rschirm, roy
sql server agent job clarifications
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?".
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?".
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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. ![Wink :wink:](./images/smilies/icon_wink.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: