If you decide to stick with the current methodology, here's the how:--USE [AdvWorks]
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE PROCEDURE [dbo].[usp_dbo_create_views_triggers] (
    @Database_Name sysname
)
AS

You need to make the entire set of code dynamic, as having your USE statements separately executed makes them useless.   Alternatively, you could instead use sp_MSForEachDb, which is undocumented by...

Make sure your job step actually fails the job if it fails.   Also check your stored procedure to at least be sure it produces a recordset.   Finally, verify that your...

Try this on for size.  I'm assuming that the estimated monthly payment in your temp table was already calculated as the payment and that I didn't need to compute the...

Well, ... I'm guessing very few people mess with ROLLUP or with GROUPING SETS, so I've gone ahead and SELECTed from the query above as a sub-query, with an ORDER...

When you say purge, exactly what does that mean?   If you don't need ANY of the data, it might be prudent to make a FULL backup and LOG backup for...