The message is the job name, last run status and start time.message = message:char(10):JobName:"|":messagebody:"|":StartTime
OPENSEQ "G:\DataStage\Incoming\jeff.txt" TO FILE
ELSE CREATE FILE ELSE ABORT
WEOFSEQ FILE
WRITESEQ message TO FILE ELSE STOP
I'd like this to handle multiple jobs, but when it loops around to handle the next job it concates the new message to the old message (previously written to the "jeff" text file. I have the message variable cleared so it starts fresh with the new job, but the problem is that it writes to a single row in the text file. Is there a way to specify a new line when the job loops?