DSXchange

That script does a reset if needed.

I posted a shell script which looks at the current job status. If the job aborted then it does a dsjob -RESET before it tries to start the job.

http://www.dsxchange.com/viewtopic.php?t=93365 is where RunJob.ksh is. It is well documented perhaps over documented.

I understand.

I do not think any DataStage server is certified on Windows XP no matter the service pack level. The clients will run fine on XP if you apply the DS patch.

No the sequence itself does not reset automatically. If you compile it then it will not restart at the point of failure. The jobs within the sequence will reset themselves if you select that option on the job activity. Most of the time the sequence does not abort. It finishes with a warning.

I posted a new EtlStats on my tips page. If you find any errors then let me know. It should be easier to install now. The installation instructions are included. I do not included the html documents or the compiled jobs. So the zip file is a lot smaller. I created categories for all the jobs which i...

They are on Windows.

Th problem is you could mess up your project. If you really want to do this then SQL DELETE 2 tables DS_JOBS and DS_JOBOBJECTS should do the trick. There is a API call to delete a job as well. You might be able to figure out the DELETE by figuring out how these tables relate to each other. Let us kn...

I would not worry about the pace. They can always rewind it and play it again. It was hard to see the screen details.

jandersen

Which part do you need help with the email attachment or the getting the row counts?

Back to ghost table. There are 3 ways in most stages to create the source SQL. You can generate it, user defined and one more. These are all stored in the record. So if you switch from generated to user defined then the table name can get out of sync with real tables used in the user defined SQL the...

Of course I use DwNav but I am biased. I don't see any other way to find these dependencies. Here is some SQL which will find any string. SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@REC...

If you are talking about removing duplicates then you can search for this. There are lots of posts on removing duplicates. You can do it using a hash file or land your data in a staging table and then select distinct.

Please call it sequence and not sequencer. A sequencer is a stage type used in a job sequence. We do not want to upset Ray. Job sequence and batch job are the proper terms. Be nice to Ray. He has been nice to us.

EtlStats can get almost everything you requested. It is free. Download it from my tips page. I should post the new version this weekend. It should include target table names. Source table names are buried in User Defined SQL so I do not parse the SQL to find these yet. All of these jobs put their re...