DSXchange

Are these job interview questions?

Are these job interview questions?

This runs on the client. If it cannot find dsdesign.exe then you need to fix the path otherwise the DataStage client is not installed.

Do a search for DEPEND_JOBS and this is a good post http://www.dsxchange.com/viewtopic.php?t=93446

This post http://www.dsxchange.com/viewtopic.php?t=99047 shows how to report on sequences.

Actually this is the right forum. A sequence is a server job. There is a job called EtlChkSeqJobsNotRun which will loop through all jobs in a sequence and email you the logs of the ones that failed or had warnings. This job is a part of EtlStats. It normally gets called by DSJobReportDbDriverNoWait ...

You should have a file DSD_BP.0/DSP_Close.B below the project. You should be able to copy this file from another project. I would say it has been deleted, corrupted or you do not have read permission to it.

If cron fails then you should get an email saying what happened.

Look at http://www.dsxchange.com/viewtopic.php?t=103074

I have seen this error before. If I remember correctly it is because you are trying to process 2 repeating groups at the same time. That was what kept DSJobReport job from working when I downloaded it from ADN. I had to change it to what is in DSJobReportDb now. This is a job that is in EtlStats. I ...

You will probably need to edit these anyway to fix the path to DataStage client files.

You need to edit the bat files to see what directories are hardcoded. Normally they are installed in C:\DataStage\KimD\Scripts. There also needs to be a C:\DataStage\KimD\Backups directory unless you edit the files.

Ray the description field in DS_JOBS does not match the one in DS_JOBOBJECTS. I would create ShortDesc field before importing the metadata as Ray described. Here is the SQL for your UV stage. INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM ) VALUES ( 'ShortDesc', 'D',...

I think you need to quit asking questions and try something. Let us know if you get it working. You can talk this to death.

What we consider as fatal sometimes is just another warning. It is misleading.