DSXchange

Why not separate projects?

The elapsed time is based on after the SQL statement returns. This changes the rows per second number. I know, weird.

They are char(251) to char(255) that are probably the problem.

It is possible to have duplicates without it being broken. If you have a space in a key then it will look like a duplicate. I agree with Arnd, I think this is broken.

Please edit your post and put code tags around the program list. This will save you indentation. Makes it easier for us to understand. Thanks.

EtlStats uses a shell script to send email and do attachments in UNIX. It uses blat.exe for Windows. You can dig into the code and see how it works if you want an example.

I got to thinking something has to trigger the client to reload to the statuses because a compile, a reset or a job finishing will force the client to reread the status file. I think it you took the code in http://www.dsxchange.com/viewtopic.php?t=89607&start=15 and added a reset on a job instance that did not exist this would work.

Hacking is fun.

All worthless.

We got tons of D.

Thanks

One word EtlStats.

In one of the newsletters I talked about estimation. I also talked about documentation as a part of a checklist. I think it was a different article.

Craig, do you think we could pass Ray's health check? It would be fun trying.

Good point. In the osh is there anything that identifies the job like link name? If so then I would try get list jobs and links with a SQL statement into sequential file like: project,job,link I would grep for the link name then only run dsjob on the limited list. dsjob on every job in every project...

I posted your 1. solution on ADN a long time ago. I think it is on my tips page. If you have EtlStats installed then you run a SQL statement to generate the html index. If any column ends in ".htm" or ".html" then it turns it into a link. The job called GenHtmlFromSql does this for you. It will turn...

Do it in a routine. I think it would be a lot easier using a Case statement.