DSXchange

hmmm...This is why i ask. I have a sequencer job multipul stages. In one perticulare stage has three links two ok(conditional) and one failure(conditional) The job that was running posted two warnings, but it only processed two rows. this is normal the job did what it was intened to do (except for t...

In a sequencer job if i have a link set conditionaly to OK, if the job that is running posts a warning, will it continue to the next job in the string?
Jim

WOOHOO I got circles around my trash can!!!

Jim

Sorry, forgot about that little 'feature' for Before/Afters. What we do is pass in delimited strings as the 'InputArg' and then use FIELD to hack it up into individual parameters inside the routine. Could be whitespace or pipe delimited, or whatever works with the nature of the data being passed in...

When you originally define a Routine, it defaults to having one input parameter called 'Arg1'. In the 'Arguments' tab, you can add and rename the parameters listed there, much like you can do the same thing in a Transform or any other grid like that. It is helpful to name them something meaningful ...

I realized that I wasnt actualy using the parramiter that I had available to me so I did, but I would still like to know how to add a paramiter to a before/after routne
Jim

What exactly are you saying Ray? That the way that chulett helped me is not the best way to do this? Sorta. :wink: Best is to only include the JOBCONTROL header if it needs to be included. $IFNDEF basically means "If Not Defined", so Ray is checking and only "defining" it if it ...

I hate seeing two experts talk to each other about my post....Its always way over my head :) What exactly are you saying Ray? That the way that chulett helped me is not the best way to do this? Also there was one thing that disrupted my sleep last night: My working code is as follows $INCLUDE DSINCL...

You need to add this at the top of the routine to get it to compile: $INCLUDE DSINCLUDE JOBCONTROL.H Also note that your error will never get passed out if there's a problem. You need to add an 'else' in there. :wink: I took that IF then stuff out just to test....AND IT WORKED!!!!! Tomorrow ill get...

I feel stupid but where is the option to run this routine after the job is done. I see plenty of places for on completion run sub routines...but im comfused...as usual. :lol: No worries. As long as you've declared it a 'Before/After Subroutine' instead of a 'Transform Function' Routine when you cre...

this error may be whats going on Compiling: Source = 'DSU_BP/DSU.CorrectedTimeStamp', Object = 'DSU_BP.O/DSU.CorrectedTimeStamp' * WARNING: Variable 'DSJobStartTimestamp' never assigned a value. Compilation Complete. this is the code that im tring to compile ErrorCode = 0 ;* set this to non-zero to ...

It's DSJobStartTimestamp . :wink: Something quick for you to expand on: FileName = Ereplace(Ereplace(DSJobStartTimestamp,":","_")," ","_") CmdString = "\\scrbbususcnc04\ETL_Processes\456msg\Batch_files\456Move.bat ":FileName Call DSExecute("NT&...

FYI, TimeDate() gives you output in a little different format than your original JobStartTimestamp - "09:59:51 03 JUN 1997", to quote from the Help. I couldn't help with the Transform routine unless I can see the entire routine, including what it passes back as 'Ans'. And yes, you can add...

Im imputing this in the after job section of the job. Just like this call \\scrbbususcnc04\ETL_Processes\456msg\Batch_files\456Move.bat #DSJobStartTimestamp# how do u put in a routine here? Well, there... you can't. If this is a parameter to your job, do you have an opportunity to manipulate it bef...

I have a need to edit the JOBCONTROL.H No, you don't. :) Not only that, but you shouldn't be doing stuff like that - IMHO, of course. Why not just write a Routine to take the format coming from the DSStartJobTimestamp and manipulate it to get the output format you are looking for? Sounds to me like...