DELIMITER $$

CREATE TRIGGER `new_email` AFTER INSERT ON `dbmail_subjectfield`
FOR EACH ROW BEGIN

SET @exec_var = sys_exec(CONCAT('/bin/sh /home/vxp/veng/bin/deadweight ', NEW.id));
END;
$$

DELIMITER ;

##</code><code>##

[vxp@vader bin]$ cat deadweight
#!/bin/sh

echo `date` >> /home/vxp/veng/deadweight.log
echo "Sleeping for 20 seconds" >> /home/vxp/veng/deadweight.log
sleep 20
echo `date` >> /home/vxp/veng/deadweight.log
echo "executing /home/vxp/veng/bin/email_retrieve.pl $1" >> /home/vxp/veng/deadweight.log
/home/vxp/veng/bin/email_retrieve.pl $1
[vxp@vader bin]$