DSXchange

Of course I can fetch information from the DSODB and build my own dashboard around it, but that's not the main question here. I doubt that the status of the dsrfcd service isn't even captured and written to the DSODB, which would be first part of the customization concept. Including this information...

We are running DataStage with the dsrfcd daemon which is to provide communication to the SAP system. Is there a concept or manual on how to customize the Operations console to show the status of processes like this in addition to the other services like appwatcher, resmonapp and so on? (Maybe there ...

We are currently migrating from DS 8.7 to 11.3. In DS 11.3, when I try to generate a Report on any job using the DS Designer GUI, I am prompted for some parameters as usual, but after clicking to proceed in this dialogue, I see the busy-circle-cursor for some seconds and nothing more happens. I get ...

Please read this sticky thread: :arrow: http://www.dsxchange.com/viewtopic.php?t=96330 This will help you to help us helping you. :wink: :idea: Add a Transformer stage to your Job with 3 output links. In Transformer, map the ID field to all output links. Then use a Funnel stage to "Union all&qu...

Thank you! Based on this, we developed a query that enables us to find jobs that read or write a specific table. Note that we used following variable identifier ${ my_var }$ in this script. (This is default in DbVisualizer) SELECT J.NAME_XMETA JOB_NAME , S.NAME_XMETA STAGE_NAME , S.HAS_INPUTPIN_XMET...

Ok, this should work: Step 1: Run the Job Setting a UserStatus. Do not use the -userstatus option. use the -jobstatus option. The Exit code will tell you, if the Job has run ok or not. Step 2: Use this command to retrieve the user status: dsjob -jobinfo <project> <jobname> 2>/dev/null | grep -e &quo...

Thank you for replies, fast as always. In particular it does not return an exit status. That is the purpose of the -jobstatus option. I made tests on a suse linux machine. I wrote a ServerJob: ORA --link1--> TRA1 --link2--> TRA2 --link3--> SF ORA SQL: select #value# as status from dual; TRA1 sets th...

Using a ServerJob, I'm Setting the Userstatus depending on an SQL requets result. Say if the rowcount of a table equals Zero or not, the userstatus is set to 1 or 2. When running this Job within a sequence, it's possible to fetch the userstatus and use it as condition or as Parameter for the next jo...

Does "later versions" mean 8 and up?

In 7.5, i don't see it...

Thank you. I searched the Documentation and it sais I have to set the variables using the DS Administrator. But I cannot find any of that variables there and if I try to add APT_MONITOR_TIME, I get an error message that sais "An environment variable of that name already exists". I also sea...

I'd like to turn the automatic refreshing off, but in tools>options i have only the possibility to set the interval to sth. between 2 and 65 seconds, but how can I disable it?

Thanks Craig, I think I got it now.

This is not helpful. Please tell me, if the description of my problem needs to be clarified..

Thank you, Ray (and Kim, by the way... :p ) I'm not sure, if I really understand that. The sequencer stage is an easy way to have an output link that does nothing. So far so good, but what would happen without the output link? I thought a job was always restartable unless it aborts, isn't it? And wh...

Dear Mr. Kim,

could you please explain in short words:

What is the advantage of using a sequencer stage as last stage in Sequence after using DSJobReportDbDriver(NoWait) like you did in SeqJobStatus for example?

Should I do that too, when adding DSJobReportDbDriver to my sequences?