DSXchange

I don't have a UNIX machine to test this but it should be close. If you finish it then post it. ps -ef | grep DSD.RUN | grep -v grep | while read LINE do set - $LINE JOBNAME=$4 dsjob -report $JOBNAME >>jobstats.txt done I think this is what they wanted you to try to figure out. You can lookup the sy...

balajisr is correct. Make Server the first topic. I think that would help.

Not me. Tell them to repost in the correct forum. You have told some of these over and over and still they post in the wrong forum.

DO NOT ANSWER THE QUESTIONS. It is our fault for answering these questions.

This script is called DsSearch1.sql. It is part of EtlStats.

Good hacking ahead.

Instance id is field 7 of RT_LOG. Here is the SQL. select TIMESTAMP, SEVERITY, FULL.TEXT from RT_LOG:1 where EVAL "@ID" NOT LIKE '//%' AND EVAL "@RECORD<7>" = ':2' order by TIMESTAMP ; Change :1 in the Job number. You need to list DS_JOBS to get the job number. Change :2 into the...

I stole this code from an old program which I did before I knew about DSPrepareJob. * Setup EtlChkSeqJobsNotRun.SeqName, run it, wait for it to finish, and test for success hJob2 = DSAttachJob("EtlChkSeqJobsNotRun.":SeqName, DSJ.ERRFATAL) If NOT(hJob2) Then Call DSLogInfo&#...

t-shirts.

Best 3 word answers ever. "Take. Adapt. Shine." pretty good too.

Can I barrow "Take. Adapt. Shine."?

It does store separate status values for each instance. Not sure about UserStatus. Why do you need to know?

I fixed this code. It does work but still I do not recommend it. I would change it to delete only old records if I was going to use this.