DSXchange

How are you getting the status of your job?

chulett wrote:That was Bill, or Chuck or whatever 'nom de plume' DSGuru2B is operating under today.

Still a Mystery

You can do that in the sql itself. I think using the Collasce function. NOt sure, google for it.

The input is now different from what you originally started with and hence the ICONV/OCONV expression will change. Also, ICONV/OCONV will not work for timestamps, you have to substring the date part and then use ICONV/OCONV.

I agree. Thats why i never use UserStatus. I like things being physically written to the disk. Especially if its controlling the process.

So user status is job specific but still user status set by job x can be retrieved in job y. Great, thanks Ray.

Thats what i thought too. Well, guess email format check is all that can be done. [sigh]

Really. I was under the impression that you have four variables (UserStatus) which you can set and were job independent. I never used User Status and hence my in-experience. Thanks for the clarification Craig. Sorry Ahimsa for the wrong info.

Ill definately combine the checks. I'll also add the .NAME and .INFO. Tell me this, isnt there any way where we can open a socket via Basic coding. I was thinking of doing something in those lines to check for a valid DSN. Even if i want to something at the OS level, some companies have there ping f...

Kim rules.

My Sequencer is having 4 jobs and each job is having parameter with Value = $UserStatus of earlier job. Now, e.g sequencer is aborted while procesing job# 3, 1. on restart of the sequencer, from which job# it will start? From the failed job if you made your sequence job restartable, otherwise from t...

Ok, rerun the job for just 1 record and post us all the warning messages you are getting. You are missing some warning messages that are important for debugging.

chulett wrote:TRY THAT, IT WILL WORK!

I like the humor in that.

Is this behaviour only happening with the DRS stage or with other stages as well? If you erplace the DRS stage with Sequential file stage. What happens then? Also go to the log director and i think the second last entry will tell the job stats. Check for the rows for your output link. Is that 0 too?

Yea. Thats what i meant. Sorry for being unclear. So now that you tested it with Tester, you know that somethings wrong with DSSendMail(). Try rebooting the server and see what happens.