Scheduler won't work

Scheduler won't work

Hi,

Can someone help me figure out why this script apparently fails to work with scheduler? The script is valid if executed elsewhere on the site (for instance if I stick it in the "on user input" of a field somewhere). I don't get any errors when putting the script into scheduler; it just doesn't seem to do anything when the scheduled time comes and passes (I have waited 15+ minutes).

Frankly, I find the scheduler fails to work with anything of any complexity. Will it not work with variables or something? I don't see that listed anywhere as a limitation but hell if I can ever get it to work.

Here is the code. What I'm trying to do is get it to update a list of who has not responded to an RSVP yet. I don't want to do this on submission of the RSVP form because I've got enough code in there slowing things down already on submit -this makes it a really long wait before displaying success. Being able to have this update once/day is fine with me, if I can get it to work.

  1. r  =  Monthly_Meeting  [Date_field > zoho.currentdate] range from 1 to 1;
  2. allmentors  =  Contacts  [(CIM_Role_2 = "Mentor" && Status = "Active")];
  3. temp = r.Attendance.getall();
  4. temp2 = r.No.getall();
  5. temp3 = r.Maybe.getall();
  6. MentorList = allmentors.Full_Name.getall();
  7. MentorList.removeall(temp);
  8. MentorList.removeall(temp2);
  9. MentorList.removeall(temp3);
  10. r.Not_Responded1 = MentorList;
Any help or suggestions are greatly appreciated.

Thanks,

Jim