no workflow emails are coming out of the system WITH wf_notifications.mail_status IS SET TO NULL

ISSUE:
------

   all of a sudden no worflow emails are coming out of the system
   
   all new rows in wf_notifications.mail_status IS SET TO NULL ... (should be set to MAIL)



SOLUTION:
---------

   navigate to:
   
      System Administrator -> Workflow : Administrator Workflow -> Administration
      
      and make sure that:
      
         Workflow System Administrator:  SYSADMIN
      
      or
      
         Workflow System Administrator:  *
         and
                    Notification Style:  HTML mail with attachments

WHAT CHANGED:

   A programmer updated Workflow Configuration changing "Workflow System Administrator" to SYSADMIN
   and it defaulted to "Do not send me mail" in Notification Style field.

NOTE:

   if you can't change this page set the Workflow System Administrator temporary to your USERNAME:
   
select * from WF_RESOURCES
where text like 'SYSADMIN';

update WF_RESOURCES
set text = 'YOUR_USERNAME'
where name = 'WF_ADMIN_ROLE'
and type = 'WFTKN';

commit;



RESEARCH:
----------
   
To resent notification:

   update wf_notifications
   set status ='OPEN', mail_status ='MAIL', end_date = NULL
   where notification_id=168476; 

Plus with WorkFlow 2.6, you have to :
   
   wf_xml.enqueueNotification(168476);

commit;

and confirm that queue WF_SMTP_O_1_QUEUE is started