DSXchange

Hi guys, I am working with the Slowly Changing Dimension Stage, and I am trying to write some logic for a Record Update Date. These are the requirements: If the record is not current, the record update should never be updated. If the record is current, and the update is a Type2, then the record upda...

Thanks for the reply guys. I wanted to log every parallel's job's log from the sequencer that was run.

I no longer need this done, but thanks for the ideas anyway.

Hello guys, I am writing a script that will run a sequence job. Is it possible to log all of the parallel jobs that is involved with the sequence job? The -report DETAIL only provides the Name of Job, and the times (start, end, elapse). example: ************************************************** STA...

I swear I tried it earlier and it didn't work. Now after you've said to try adding the credential, I tried it, and it worked.

Working code:
%DsJob% -server %Server% -user %username% -password %password% -report %Project% %JobName% DETAIL >> %LogFileDir%

Thanks for your help.

I get the same error running it from the Dsjob.exe.

Hi Craig, Thanks for the quick reply. This is the actual execution code: %DsJob% -server %Server% -user %username% -password %password% -run -wait -jobstatus -paramfile %pramFile% -warn %warn_limit% %Project% %JobName% %DsJob% -report %Project% %JobName% DETAIL >> %LogFileName% New error: Waiting fo...

Hi all, I'm once again stumped. I am trying to log the job details into a DS_job.log file. I'm getting the following error. Waiting for job... Finished waiting for job Job Status : (2) Status code = 2 Invalid arguments: dsjob -report [-useid] <project> <job|jobid> [report type>] report type = BASIC ...

Thanks for all your help guys. I decided to scrap the example script and just write one from scratch. No problems at the moment.

The Windows Task Scheduler is going to run the job at a specific time for now. The Job runs correctly. The problem I'm having now is the script itself. I've narrowed it down by putting an echo statement after the "SET TGTSSODSDSN=<Target DSN>" line, and the echo doesn't print in the log. I...

MS SQL Server is not compatible with the built-in scheduler in DS Director. http://www-01.ibm.com/support/docview.wss?uid=swg21669154 The end goal is to grab a file when it is written in a folder, but as of right now, we have to get a script to run the sequence job. The script is not accepting Netez...

I will be only once a day, but it will vary everyday depending on when the MS SQL Server finishes its updates.

Thanks Craig, but the job I need to run is a Sequence job(email test for now). The OS the client is running is Windows Server 2012, so job scheduling in DS Director doesn't work. We are migrating from MS SQL Server 2005 to Netezza, and need to do incremental loading for the database daily. The batch...

Thanks. I didn't know that I didn't have to specify a path to where the jobs live. Is there a more simple example somewhere I could use? I couldn't find any except for the example posted here. I'm trying to accomplish running a single job when a "done" file appears in a folder. As soon as ...

Sorry for the confusion, I'm wondering where the DataStage jobs' folder is located, so I can access the job with the script.

Thanks.

Hi all, I'm trying to run a job from DataStage using a Batch file. I am new to DataStage and new to Batch files. I'm using this batch file as a starting point. @echo off :: ----------------------------------------------------------------- :: Name: CommonProviderExtract.bat :: -----------------------...