How to Run SQL Job GUID after DataStage Job

us1aslam1us · Post by **us1aslam1us** » Mon Aug 27, 2007 10:20 am

Hi Dxians,

Can someone suggest me how to run a SQL server job GUID after the Successfull completion of the DataStage Job. I think i can use the Execute command stage to implement this but my confusion is:
* Whether we can run SQL Server Job GUID?
* What will be the optimized solution for this?

Thanks
sAM

kris · Post by **kris** » Mon Aug 27, 2007 1:22 pm

What do you exactly mean by running "SQL Server Job GUID"?

Is it a typo? you meant running a Job Report or something like that?

us1aslam1us · Post by **us1aslam1us** » Mon Aug 27, 2007 1:31 pm

Sorry, I mean a SQL job script created for publishing reports.

kris · Post by **kris** » Mon Aug 27, 2007 2:10 pm

Wrap your SQL (whatever it is that you want to call) in dos script and call it using ExecSH option in after-job subroutine.

us1aslam1us · Post by **us1aslam1us** » Mon Aug 27, 2007 3:40 pm

I got it. Thanks

DSXchange

How to Run SQL Job GUID after DataStage Job

How to Run SQL Job GUID after DataStage Job

Re: How to Run SQL Job GUID after DataStage Job