DSXchange

Ken script is great but I think it is hard to understand. I think this script http://www.dsxchange.com/viewtopic.php? ... ght=runjob is a little easier to understand.

Start with naming convetions like link names should be the table or file name. This is so Director shows link names and it makes more sense to monitor a job this way. Stage names should be database names. Transform names should start with t1, t2, t3 and so on. Project names should be DWDEV, DWTEST a...

That is exactly what I meant. Very nice so far. I think you need to add DSPrepareJob. I would also get the row counts at the same time. I posted code to do that as well. If you can't find it then I will post it again if I need to. You could post your code to go from the sequential file to the hash f...

You could replace every job activity with this as a routine activity.

Field will parse a string.


Var='12345~flkflkf~789=234'
F1=field(Var,'~',1)
F2=field(Var,'~',2)
F3=field(Var,'~',3)
F2_3=field(Var,'~',2,2)
X2=field(Var,'=',2)

Would mean:

F1 = '12345'
F2 = 'flkflkf'
F3 = '789'
F2_3 = 'flkflkf~789'
X2 = '234'

Nice.

I would use DataStage Manager. It is easier to move things around. Otherwise you can use a SQL update on DS_JOBS.

You need to use DataStageBackup.bat. You can easily schedule with this. You can download it on ADN or my tips page. It will create a directory with yyyymmdd then name the dsx Server_Project.dsx. It will backup one or all projects on this server. We put this on our test server and backup our developm...

If you really want the SQL to automate deleting old instances then let me know.

EtlStats can be run if the sequence fails or is successful. You need to have an exception handler run the main job. Otherwise run this job as the last job of the sequence. It translates 99 into the correct description. It will get row counts for all jobs, one job, all jobs in a sequence or all jobs ...

It might be DsJobReport. This is a routine you need to download from ADN.

Exactly.

Why not use a named pipe?

There is no Get_Job_Status job.

Do a search for EtlStats. It is free.