If your process is long time running process maybe you can send email to client when it is done. DTS package has this possibility or you can use SQL command inside DTS package to send e-mail from SQL server

Thanks

Janusz