DSXchange

avi21st I really disagree with some of these. Why have all links start with lnk? Why have all projects have Load in the name? If all of them have it then how informational is it? What good does it make to have job type in the link name? I do like jp and sv so these variables show where they come fro...

Do not try this on import. It will fail.

Hey Ray, where is that ReadMyMindStage?

Not exactly sure what you mean. Do you mean sceenshot? Do you mean some kind of documentation including a screenshot. If you want to document a job then you can do it several ways. In the Designer it will generate a html with the screenshot as a bmp file. You can do the same from the command line. T...

DSJobReport was an example of how to use a job filter. It was the basis for my job DSJobReportDb. DSJobReport had lots of issues. It failed all the time. I think DSJobReportDb is a lot more stable. DSJobReportDb is the basis for EtlStats. DSJobReportDbDriver is the job that executes DSJobReportDb in...

It is not an after stage or after job routine. It is a routine to use to get the results of a different job and not the current running job.

Tell them Ray man.

You can find links to sites with these documents on www.olap.it I think Ganett had my favorite source to target documents. Not sure if they are on this site or where the exact link is for these documents.

Do you mean to translate Texan to English?

Ray, you keep coming to Texas then they might need this for you. That Texan thang seems to rub off on visitors.

The first 4 are easy with EtlStats. 5 is very difficult if you have user defined SQL. I have posted SQL for ODBC stage types for 6. For other stage types it will be more work. You could use a combination of GetEtlQaSqlStat job and routine KgdCreateDdlMetadata to get 7 through 10.

Craig

Sometimes I think we are the only ones on here with a sense of humor. Just checking to see if you are reading all these posts.

I would modify UtilityRunJob() to run my jobs and have it get row counts after the job finishes.

Why do you want to call DSGetLinkMetaData()? What information are you wanting to get at?

I think I explained myself. What did you not understand? Ray does not like to see aborted jobs in the Director. He wants to control the ETL without aborting jobs. This seems pretty smart to me. There is a check box in a sequence to automatically handling aborted jobs. This requires using an exceptio...

EtlStats has a job included called EtlChkSeqJobsNotRun. This loops through all jobs to see if any had errors or warnings. All it needs is the sequence name. It sends a html web page as an attachment with the log file of the job which has warnings or errors. The job called GenHtmlJobLog will loop thr...