DSXchange

Is it possible to get via the DSGetJobInfo api function to tell if a job has multiple runs possible?

kduke wrote:Zam

I think the only change is job name is job.invocationId.

Kim.

Can I pass Multiple Job Names to DSRunJob and DSWaitforJob?

I am interested in running the same job to update multiple tables at the same time. I would like to use the "Multiple Instances on Server" functionality. We have a bunch of parameters to set and three years worth of daily information to update and we need it done(of course) by tomorrow:). ...

I am running jobs by calling them from aC program. I have checked the "Allow Multiple Instances On the Server" to run the job multiple times. IF I call the job from a C program(or dsjob), how do I specify the InvocationId? I noticed in Director that the job being run is <jobName>.<Invocati...

Yes, and it can be done rather easily(if you are familiar with C). We have created a C program to grab data from our database, populate parameters in a DS job, run the job and log performance, then check status and nofify the proper personnel if warnings or errors occurred. Most of the functionality...

I have create a C program using the DSAPI to run our DataStage Jobs. When a user tries to execute a job and does not have permissions to run datastage, I am getting a general failure in my C program because there is no corresponding error code being set. I cannot find the proper return code for a &q...

Maybe I should have been more clear on the procedure since it seemed to have been muddy. 1. Used "Insert Rows Without Clearing" and it worked. 2. Highlighted SQL in that Tab. 3. Opened the "general" tab. 4. Changed the "Insert Rows Without Clearing" in the Update Action...

I cut the INSERT statement from the Fully Generated statement that DS create and worked. I then pasted it into the User Defined Portion of the stage and got the error. I am fairly certain that all the columns match. I also ran the statement in TOAD and it worked fine. IS there something in the user ...

I have been having a problem with an insert using User Defined SQL. When I perform the INSERT, I get "EDWItem2Dim..ITEM_INSERT: ORA-01008: not all variables bound". I changed the job to use "Insert Rows Without Clearing" and it worked fine. Without changing anything else, I copie...

I have been having a problem with an insert using User Defined SQL. When I perform the INSERT, I get "EDWItem2Dim..ITEM_INSERT: ORA-01008: not all variables bound". I changed the job to use "Insert Rows Without Clearing" and it worked fine. Without changing anything else, I copie...

IS there an easy way to create a job template so when I create a new server job I can have a few default parameters and pre/post job activities?


David Abbey
dabbey@gfs.com
"...Rise Above..."

We are currently in the process of changing quite a few of our field sized in various Oracle Databases. The difficult task is finding out what fields are used in what jobs. I run the Usage analysis for the tables and sometimes I get the resulted jobs. However, some of the table definitions were adde...