		return rowsUpdated;
	}

	// 2.4
	public int countAndDeleteCompletedNoFailure(Job job) throws SQLException {
		Connection c = null;
		PreparedStatement pp = null;
		try {
			c = connectionProperties.getConnection();
			pp = c.prepareStatement("DELETE FROM unit_job WHERE processed = 1 AND job_id = ? AND status = '" + UnitJobStatus.COMPLETED_OK + "' AND confirmed = 0 AND unconfirmed = 0");
			pp.setInt(1, job.getId());