You can get notification from any long-running task on the command line like this:
do_my_task && make_a_sound
For example, using Rake on a Mac:
rake db:reseed && say 'done'
Now I can kick of the database to be rebuilt and move to another window, knowing that I'll get audible notification when that task is complete.