Just How Long Is Too Long?

Just how long is too long for a SQL Server stored procedure to execute? Seconds? Minutes? Weeks? Yes, I said weeks…