CREATE PROCEDURE mis_CreateCustomJob (
	@strUserName varchar(50),
	@strDateTimeStamp varchar(14),
	@strJobType varchar(10),
	@intDate int,
	@intTime int
)

AS
	BEGIN TRANSACTION            
		DECLARE @JobID BINARY(16)  
		DECLARE @JobName VARCHAR(67) 
		DECLARE @ReturnCode INT 
   		SELECT @JobName = 'jb_' + @strUserName + @strDateTimeStamp

		SELECT @ReturnCode = 0

	BEGIN 

		-- Add the job
		DECLARE @strDescription VARCHAR(100)
		SELECT @strDescription = 'Job aangemaakt met MUC door ' + @strUserName
		EXECUTE @ReturnCode = msdb.dbo.sp_add_job 
			@job_id = @JobID OUTPUT ,
			@job_name = @JobName, 
			@owner_login_name = N'misAdmin', 
			@description = @strDescription, 
			@category_name = N'[Uncategorized (Local)]', 
			@enabled = 1, 
			@notify_level_email = 0, 
			@notify_level_page = 0, 
			@notify_level_netsend = 0, 
			@notify_level_eventlog = 2, 
			@delete_level= 1
		IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 

		-- Add the job steps
		DECLARE @strCommand varchar(100)
		SELECT @strCommand = 'SET ANSI_NULLS ON' + char(13) + 'SET ANSI_WARNINGS ON' + char(13) + 'go ' + char(13) + char(13) + 'exec mis_JobTest'
		EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep 
			@job_id = @JobID, 
			@step_id = 1, 
			@step_name = N'Upload Contracttabellen', 
			--@command = N'SET ANSI_NULLS ON' + char(13) + 'SET ANSI_WARNINGS ON' + char(13) + 'go ' + char(13) + char(13) + 'exec mis_JobTest',
			@command = @strCommand,
			@database_name = N'mis', 
			@server = N'', 
			@database_user_name = N'', 
			@subsystem = N'TSQL', 
			@cmdexec_success_code = 0, 
			@flags = 0, 
			@retry_attempts = 0, 
			@retry_interval = 1, 
			@output_file_name = N'', 
			@on_success_step_id = 0, 
			@on_success_action = 1, 
			@on_fail_step_id = 0, 
			@on_fail_action = 2
  			IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 
			EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1 

			IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 

			-- Add the job schedules
			EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule 
				@job_id = @JobID, 
				@name = N'HandmatigeUpload', 
				@enabled = 1, 
				@freq_type = 1, 
				@active_start_date = @intDate, 
				@active_start_time = @intTime
			IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 

			-- Add the Target Servers
			EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver 
				@job_id = @JobID, 
				@server_name = N'(local)' 
			IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback 

	END
	COMMIT TRANSACTION         

	GOTO   EndSave              

	QuitWithRollback:
  		IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION 
	EndSave:
GO