定时清理数据

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：









1、问题描述最好图文并茂，如有视频/脚本可直接放出，这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决，请在该帖子下回复\"已解决可结帖\"

说明：
         任务可以让系统在特定日期特定时间执行指定的任务内容，并通过终止条件结束任务。
/*方法1：定时清理符合SQL清除条件的数据*/

var sql = "delete from tlk_qs_user_enterprice_info where istmp=0 and ";

sql += " item_username in(select tlk_qs_user_enterprice_info.item_username ";

sql += " from tlk_qs_user_enterprice_info where istmp=0 and not exists(";

sql += "select t_qe.item_username from t_user,";

sql += " tlk_qs_user_enterprice_info t_qe where t_user.id=t_qe.item_username))";

var process = new Packages.cn.myapps.runtime.dynaform.dts.datasource.ejb.DataSourceProcessBean();

process.remove("del",sql,getApplication());



/*方法2：定时清理符合SQL清除条件的数据*/

//2.4版本及之后可使用

var sql = "delete from tlk_qs_user_enterprice_info where istmp=0 and ";

sql += " item_username in(select tlk_qs_user_enterprice_info.item_username ";

sql += " from tlk_qs_user_enterprice_info where istmp=0 and not exists(";

sql += "select t_qe.item_username from t_user,";

sql += " tlk_qs_user_enterprice_info t_qe where t_user.id=t_qe.item_username))";

deleteByDSName("del",sql);