DSXchange

I disagree. I think MCM is very buggy.

Will it run one job? Make CategoryToDoc the job you want to test and run it with the routine uncommented out.

Adjust the size down for smaller than 2GB files.

Do you have this line in your job? Deffun JobReport(JobName,OutputDirectory,LogoPath,Style,Language) calling "DSU.JobReport" Secondly do these exist? FilePath = /interface/xx/vv/uu/reports/ LogoPath = /interface/mm/yy/rr/yy/reports/logo.jpg CategoryToDoc = MySequence CategoryToDoc ...

GenHtmlFromSql can take any SQL statement and turn it into html. If any column ends in ".htm" or ".html" then it becomes a link. The DSN for Universe is uvlocal. Now create a SELECT which reports CATEGORY from DS_JOBS. Post it here. Next add ".htm" to the column. As far as the getting the list of jo...

Ray is a truly awesome instructor. I took one of his classes too. Thanks again Ray for all your efforts.

Refer to http://www.dsxchange.com/viewtopic.php?t=93446&start=15 Sorry if I sound upset. I am not. I am just tired.

I have seen the @ symbol mess up other commands. I think it is the shell. What is your hardware and OS release number?

Secondly, please run job KgdGenHtmlJobDocs and where it asks for a CategoryToDoc put in the job category name instead of all.

If you are using EtlStats then it is a little different. You can give the job GenHtmlFromSql a SQL statement and it will turn it into an html document. SELECT CATEGORY || '.html' AS CATEGORY FROM DS_JOBS; Any column which ends in htm or html will create a link to another html web page. So just save ...

JobReport was not written by me. It was written by an IBM employee. They protected it by exporting without source. There one other routine in EtlStats which is protected. There is enough code to do what you want. If you are using GenHtml then you can feed it one category at a time. Instead of using ...

These will not help you. These scripts allow you to create 2 projects where the 2 groups cannot see the other's project. If you want one project protected from specific users then that is a lot easier. You just add the users to /etc/groups into the new group. Next you restrict this project to that g...

They were posted a long time ago.

http://www.dsxchange.com/viewtopic.php?t=95616

There is a job called EtlChkSeqJobsNotRun included in EtlStats. It will email you the log of the jobs that fail or finish with warnings within a sequence. You need to get all the jobs working.

I thought the tables were:

APM_BATCH
APM_BATCH_MEMBERS
APM_VERSION
APM_VERSION_XREF