Skip to Content
0

Change of a parameter of a scheduled System_Mail_Send

Mar 14 at 02:17 PM

26

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

G. Blom Apr 11 at 09:44 PM
0

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

Regards Gerben

Share
10 |10000 characters needed characters left characters exceeded