DSXchange

First of all you should post a new thread instead of hijacking this one. The backup batch file is on my tips page and you can download it for free. I think most people have a version of this now. Talk to my boss Sheila Wright and maybe she will let me post these versions. Only one was invented on my...

Try it and let us know.

http://www.dsxchange.com/viewtopic.php? ... JOB.STATUS is my post mostly. It does not work any more. It is a hack but I think it was useful. You can easily do the same thing by writing out the value to a sequential file and reading back in every time you need it.

What job info do you want? JobName, LinkNames, StageNames or run time info like row counts?

I don't think that was needed. I think more people have used sudo than Power Broker.

pbrun is like sudo. Got it. dsadm probably owns the files therefore has more rights.

the logic behind what I did is in http://www.dsxchange.com/viewtopic.php? ... ght=JobAct The job itself is part of Parameter Navigator. You need to buy it.

On my tips page there is a DataStageBackup.bat file. I modified this to do exactly what you asked for. It is a simple change.

I wrote a job to automatch the parameter in the sequence to the one in the job being run. This job is a part of Parameter Navigator. I posted some of the code. Do a search. We had about 500 jobs which we added about 6 to 12 parameters. There were 90 or more sequences. I figured this would take weeks...

Sounds like a job interview question. We do not answer job interview questions.

1. Select fewer records.
2. Write fewer records.
3. Do less transformations.
4. Do transformations faster.
5. Change your sources.
6. Change your targets.

I have not looked at this code in a couple years. Make sure OutputDirectory exists. Make sure JobReport exists in your routines. LogoPath is a jpg for your comapny logo. Does it exist.

I haven't spent a lot of time documenting all the features. Too much work. I would rather add value than sell more copies. You want it then buy it. It works well for me.

It can do a lot more than that. It can change all parameter defaults in a project from DEV values to TEST values in one click after a little setup. That way someone does not update the wrong database by accident.

I posted a routine like this a while back. It may still be on my tips page. I think it is in EtlStats as well.

I don't think Dennis sells Parameter Manager any more. He sells Parameter Navigator instead.