set subjects_list [db_list aaa "select unique uned_subject_id  from alf_ehea_subjects vea join v_ehea_grados_asignaturas vega on
          (vea.uned_subject_id = vega.cod_estudios_asignatura and vea.term = vega.curaca) where term = '2011' and cuatrimestre = 2 and state = 'a'
and (to_char(last_sync_date,'YYYYMMDD') <> to_char(sysdate, 'YYYYMMDD')
or last_sync_date IS NULL) order by uned_subject_id"]

foreach subject $subject_list {

    with_catch errmsg {
        integracion::ehea::sync::subject::students -uned_ehea_subject_id $subject
        bs_log Notice "EHEA MANUAL: $subject sincronizada"
    } {
         ns_log Notice "EHEA MANUAL: Fallo al sincronizar usuarios en $subject : \n$errmsg"
   }
}