定时清理符合SQL清除条件的数据

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







定时清理符合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))";
deleteByDSName("del",sql);