DECLARE @server_name NVARCHAR(100),
          @database_name NVARCHAR(100),
          @job_id UNIQUEIDENTIFIER,
          @job_name NVARCHAR(100),
          @schedule_name NVARCHAR(100),
          @step_name NVARCHAR(100),
          @active_start_date NVARCHAR(100),
          @active_start_time NVARCHAR(100)

  SET @server_name = @@servername;
  SET @database_name = DB_NAME();
  SET @job_name = CONCAT('JOB.', @job_code); ;
  SET @schedule_name = CONCAT('SCHEDULE.', @job_name);
  SET @step_name = CONCAT('STEP.', @job_name);
  SET @active_start_date = CONVERT(VARCHAR(8), GETDATE(), 112);
  SET @active_start_time = REPLACE(CONVERT(VARCHAR(8), DATEADD(SECOND, 10, GETDATE()), 108), ':', '');

  SELECT @conf_job_log_id,
         @command,
         @active_start_date,
         @active_start_time;

  EXEC msdb.dbo.sp_add_job @job_name = @job_name,
                           @enabled = 1,
                           @delete_level = 3,
                           @owner_login_name = N'sa',
                           @job_id = @job_id OUTPUT;

  EXEC msdb.dbo.sp_add_jobstep @job_id = @job_id,
                               @step_name = @step_name,
                               @subsystem = N'TSQL',
                               @command = @command,
                               @database_name = @database_name;

  EXEC msdb.dbo.sp_add_jobschedule @job_id = @job_id,
                                   @name = @schedule_name,
                                   @enabled = 1,
                                   @freq_type = 1,
                                   @freq_interval = 0,
                                   @active_start_date = @active_start_date,
                                   @active_start_time = @active_start_time,
                                   @active_end_date = @active_end_date,
                                   @active_end_time = @active_end_time;

  EXEC msdb.dbo.sp_add_jobserver @job_id = @job_id,
                                 @server_name = @server_name;