Convert to day

nandela.sudheer · Post by **nandela.sudheer** » Mon Jan 21, 2013 11:22 pm

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.

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jan 21, 2013 11:54 pm

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

nandela.sudheer · Post by **nandela.sudheer** » Tue Jan 22, 2013 12:04 am

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

vamsi.4a6 · Post by **vamsi.4a6** » Tue Jan 22, 2013 12:26 am

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.

nandela.sudheer · Post by **nandela.sudheer** » Tue Jan 22, 2013 12:35 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Jan 22, 2013 1:17 am

Custom trigger:

Code: Select all

 Mod(@DATE,7) <= 1

nandela.sudheer · Post by **nandela.sudheer** » Tue Jan 22, 2013 1:23 am

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

Is it correct?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 22, 2013 4:33 am

Yes, this was your requirement.

vamsi.4a6 · Post by **vamsi.4a6** » Tue Jan 22, 2013 7:08 am

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

chulett · Post by **chulett** » Tue Jan 22, 2013 7:32 am

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.

vamsi.4a6 · Post by **vamsi.4a6** » Mon Mar 04, 2013 3:33 am

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?

chulett · Post by **chulett** » Mon Mar 04, 2013 7:43 am

@DATE returns the internal value for the current date.