DSXchange

Hi, I want to clean up a category that is full of jobs where lots of them are not in use. To see what jobs are not used, I would like select all jobs that did not run the last time (60 days or so) and move them to a sub categrory named "obsolete". Can I do this using command line tools or ...

You guys rock! Using the {FILE} Syntax seems to work. (I still have to correct my 40 columns set, but the error message shows me the SQL from the file.) Mark mentioned that he had to specify a slash in front of the pathname variable. I tried some syntax and found out that it simply doesn't matter wh...

Hi, using the seach, I found this thread: http://www.dsxchange.com/viewtopic.php?t=86881 but since I'm not using an oracle stage and the thread above seems to be outdated, I apologize for this new thread. Based on input Server Job parameters, I need to generate different (completely different) where...

Thank you for the fast replies. I'll try that.

Hi, I installed Kim Duke's ETL Stats. All I need is the content of the table ETL_JOB_HIST. I don't need the generated HTML files (they remain empty anyways... but thats another case.) I have DSJobReportDbDriver attached to our main sequence and one of the (Main-) sub-sequences. The whole processing ...

I solved the problem. I've used sysinternals process explorer to be sure which process I had to kill. It shows the command line that has been used to start the process, so I could see the job's name.

Hi folks, I have made an error last week. I've made a lookup on a DRS stage and tried to use a user defined SQL. That resulted in getting the whole lookup table for each input row, so I got the Error Reference lookup generated <n> rows. Only the last row was used. In this case, n was quite huge, the...

You may also use dynamic paths in your batch. Detailed information can be found in the "Help and Support Center" in Windows. (Start > Help and Support). Search for "Using batch parameters" and bookmark it. There is also a quite good "Command-line reference A-Z". :wink:

srinath wrote: Please see below link, it may be helpful to you

viewtopic.php?t=84569&highlight=read-on ... re+omitted

Thank you, I wonder why I got no matches when searching the forum for "dscmdexport omit"...

guess I have to excuse my beginners-question

Hi experts, with kim duke s export batchfile I managed to export my project every night. Controlling the log file and export file, I see that the size of the exported dsx file is about 160 MB, but at initial run two days ago it was 240 MB. In the current log file I have a line saying 375 read-only o...

I think you need an else clause at the end because the compiler needs to be sure, that in every situation you'll get some result. What if arg1="crap"? Saying your variable is called "someValue", the following example should work (delete the comments): if arg1= '+' then res=a1+a2 ...

DSguru2B wrote:Use the following query and thank Kim (kduke) for it.

Thank you... and thank Kim, that worked well.

@chulett: I think I know what you mean. I'll try that, thank you, too.

@asitagrawal: Thank you, i didn't know about that functionality in the Manager. But even if I get all hash files listed, I still have problems to find the one i need, because they are all prefixed with the Job Name and cannot be sorted by stage name nor searched in cause of a missing search function...

Hello experts, I often have to check backwards how the source file of my current server job is built and in which job that happens. But sometimes, the names of the jobs are kind of cryptic. Looking for a jobs category can be done using the DS Administrator. With the statement "SELECT NAME, CATE...