Yes its a Store proc which gets called remotely and the restore happens through network. Now if I have to add a another step or another few lines in that Store proc. I need to go through SDLC(Dev & Engg) and which is going to take a lot of time.
Instead I would like to design a job on the target server which checks the msdb..RestoreHistory . If I have the database with today's time stamp, then shoot and email saying Publish is complete. Out database publish happens only once a day.
Not sure how to tweak the column "Restore_Date" according to my requirement which is today's Time stamp.