• Then write a service or another app that process the orders and sends the pdfs.

    That should NOT be handled by SQL Server.