Skip to Content

Change of a parameter of a scheduled System_Mail_Send

Hello,

I have a lot of jobchains with some steps and at the end of the jobchains there is a job System_Mail_Send with certain information e.g mail address abc.xyz@company.com

Now I want to Change the mail address in all jobchains.

I wrote a script:

import java.util.Iterator;
import com.redwood.scheduler.api.model.*;
import com.redwood.scheduler.api.model.enumeration.*;

{  
  String strSuchString = "abc.xyz@company.com";  
  Iterator itJobParam = jcsSession.executeObjectQuery("SELECT * from JobChainCallInExpressionParameter jcp WHERE jcp.Expression = ?", new Object[]{strSuchString});  
  if(!itJobParam.hasNext())  
  {  
    jcsErr.println("No jobs found");  
    jcsJobContext.setReturnCode(101);  
    return;
  }  
  while(itJobParam.hasNext())  
  {  
    JobChainCallInExpressionParameter jcp = (JobChainCallInExpressionParameter) itJobParam.next();    
    jcp.setExpression("aaa.bbb@ycompany.com");  
  }    

  if(p_TestRun.equals("N"))  
  {  
    jcsSession.persist(); 
  }
}

Unfortunatelly it works only if the jobchain isn't scheduled.

How I have to change the script for changing scheduled jobchains too. The jobchains are not running at the moment of the change, they are only scheduled for the future.

Thanks and Best regards

Dana Ullrich

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 11 at 09:44 PM

    You can call job.updateJob() on the top level job of the scheduled jobs that use these definitions.

    Regards Gerben

    Add comment
    10|10000 characters needed characters exceeded