One spot where you can view that info is in the Job Activity Monitor.  You'll find a 'Next Run' column there.

This might be one solution:

select

top 1 bs.backup_finish_date, bs.database_name, bs.

Here's a rewrite of your proc.  The syntax was a bit off for an update statement and I'm supposing you'll also need to pass in the venue value to select...

You might try sp_grep.  Look at http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1201