DSXchange

It is pretty easy to copy parameters from one to another. I posted a routine. Ken Bland posted one. You can buy ParameterNavigator. Do any of the values remain the same between one job run to the next or can you programatically determine the values? If so then create a batch job. A batch job only ha...

Why do you need to drop and recreate? What about truncate?

It should fail with anything greater than what shmtest says is your limit. It gives a weird error.

My suggestion is to create a RAM disk through the OS. Use this if you want to go larger. We are looking into a third party tool to do this on Windows 2003.

You really need to change this routine to look at how old the instance id is. Maybe purge anything over 2 days old.

The instance ids are stored in 2 places. The RT_LOGnnn file and RT_STATUSnnn. If you delete the correct records then it will not refresh the Director until you disconnect and reconnect. This is slightly dangerous to delete these records. If you delete the wrong records then the job may quit to funct...

There is a command which can tell you how big to make this. Do a search for shmtest.

It is on your server. Copy it to the client.

I think all ETL should be ignored in QA. You should QA the results without knowing anything about or how the ETL works. The source to target documents should be used to design QA scripts. How many rows are in your source tables? How many are in the target? If they match then compare more specific th...

No way. Much easier in RT_LOGnnn.

EtlStats gets parameter history as well as row counts. It stores the results in both tables and hash files. You can easily select th hash files and get what you want.

It is easier to schedule DataStageBackup.bat. You can download it from my tips page or ADN. Download Scripts.zip.

If you want job category: * ----------------------------------------------------------------- * GetJobCategory(JobName) * Decription: Returns Job Category. * Written by: Kim Duke * Notes: * ----------------------------------------------------------------- Ans = '' RoutineName = "GetJobC...

Here is an example:

What is your run time error? Normally the only error is truncation errors. Reporting Assistant stores its information in Access database named doc_tool.mdb. I posted the SQL to pull it out of this database. Do a search.

Do a search for RT_LOG.