DSXchange

I have Sequence job.I want to Run the sequence job only on Sunday and Monday,other days sequence jobs needs abort.How to implement logic in the Sequence job.Please help me.

In execute command stage use below command
date +"%u" which will return the 0(Sunday) and in trigger check whether it is zero or not.If it is zero means trigger the Sequence

Thanks for your help.Actually i want to run Sunday and Monday.Please let me know how to write the command in execute coomand.

No need to change anything in execute command activity.Just change the trigger condition to check whether it is 0 or 1 instead of 0.

Thanks. I have Implemented in executed command Returned value = 0 OR 1 (this is one condition for executing next level sequence job). Returned value = 2 or 3 or 4 or 5 (teriminator the sequence job).

Job design is : Excued command -------Returned value is (=2 or 3 or 4 or 5) ----Teriminator activity ------------(again from executed command) ---Return value is 0 or 1 ----Job activity.


The above condition is not working.Please help me

Custom trigger:

Mod(@DATE,7) <= 1 for Sunday and Moday
Mod(@DATE,7) > 1 for Tuesday to Friday

Is it correct?

Yes, this was your requirement.

Could anybody reply what is the reason for the problem and how to resolve it?

Probably invalid syntax. "Returned value = 0 OR 1" should in reality be "Returned value = 0 or returned value = 1" and I'm guessing it wasn't. That and the Field Mark you'd have to deal with in any Execute Command result.

Could any body please explain how it will work?

Custom trigger:
Code: Mod(@DATE,7) <= 1

Because @DATE will give Date how can we can divide date by 7?please correct me if i am wrong?

@DATE returns the internal value for the current date.