DSXchange

I am on 7.5.1A

I agree with Craig it should work. I think in ExecDOS and ExecSH they strip out quotes or do something to them. I think if you change it to execute 'DOS C:\"Program Files"\...dsjob' then it would work. The statement above is an example and not complete but completed it should work.

Here is the last step. Colin Sounds good. You need to run DSJobReportDbDriver and give it the sequence name at the end of every sequence. SeqPrepareEtlStats just needs to be run once to load the job names and link names in a table to run reports against. The last thing you need is to switch my shell...

I would change your path on the command to "..\..\Engine\bin\dsjob -report". This works for me. This is unless you move your projects from the default directory. Also I see you figured out that the before routine in job DSJobReportDb was ExecSH but should be changed to ExecDOS. Now I all need to cha...

This is sort of correct. In your job you have a primary input. You need a UV Stage as a lookup to point to this hash file. When you load the metadata then it will make the 3 fields in your key = :1 and = :2 ans so on. To change this from equal signs to >= you need to switch it to User Defined SQL.

The first thing you need to do is run SeqPrepareEtlStats. If this runs then you can start using all of EtStats.

Sorry, but I just haven't had time to clean this up and make this easy. Hope you get it working. I start a new job on Wednesday. It is on a Windoze box. I should have it cleaned up soon. Let you know.

It is finding the dsjob command but it does not like the rest of the line. You may have a special character in your password like <,> or ". These will mess up the rest of the line. I think I would quote the job name also if it starts with a zero. The same for the project name. c:\"program files...

1) Not needed. You can do this in a hash file. You can use a compound key or a key with more than one column. You could even use a surrogate key. 2) You need to lookup or use the hash file as a referrence lookup. 3) I would use 2 columns as the key. One is the timestamp or break it into 2 fields dat...

I only use UtilityAbortToLog in sequences. Sequences are server jobs but can run Px jobs. I never use UtilityAbortToLog to stop a job other than a sequence or a batch job.

Good to know.

Where is the "mate"?

Geez, Craig you are starting to talk like your from down under. You forgot the "mate" part.

Because you do not need quotes around a number. Why did you waste our time making this a lot more complicated than it should be.

DwNav is great. MetaStage should work. This link http://www.dsxchange.com/viewtopic.php?t=94738 will work.