This is currently setup for failed job notification.  change the first line to any of the other statuses if needed.  replace the xxxxxxxxxxx with the users email:

select jobs.name from jobs where jobs.fail_notification_list_id in (

  select nl.id from notification_lists nl where nl.id in (

    select nlu.notification_list_id from notification_list_users nlu where nlu.notify_contact_type='User' and nlu.notify_contact_id in (

      select users.id from users where users.email_address like xxxxxxxxxxxxxx%')))