USE [msdb];
GO

-- Note: Frequency here is used only for description (used for category): MONTHLY
-- By Default Job will be scheduled Mon to Fri at specified time. Please change the schedules as per the requirement.

-- 1.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSRQ414',
    @StartTimeHHMMSS = 181500,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 2.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSPMON1',
    @StartTimeHHMMSS = 191500,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 3.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSCHGVB',
    @StartTimeHHMMSS = 192600,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 4.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSCHGVR',
    @StartTimeHHMMSS = 192700,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 5.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSVBKUP',
    @StartTimeHHMMSS = 192600,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 6.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSVRSTR',
    @StartTimeHHMMSS = 193000,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 7.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSRQ442',
    @StartTimeHHMMSS = 193700,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 8.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSBX460',
    @StartTimeHHMMSS = 193500,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 9.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSRQ513',
    @StartTimeHHMMSS = 193700,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';

-- 10.
EXEC dbo.usp_CreateSQLAgentJob 
    @JobName = 'PROD_MONTHLY_DTSCHGDC',
    @StartTimeHHMMSS = 130000,  
    @Env = 'PROD',
    @Frequency = 'MONTHLY';
GO
