Uncancel jobs

Uncancel jobs

delete from tbl_invoicehistory where id=(select h.id from tbl_parentinvoice
as p ,tbl_invoicehistory as h

        where p.id=h.invoiceid and h.detail='' and h.action='converted'
              and p.invoicenumber='4008')

Change the number with the job number.