Job 2

--  [dbo].[usp_Institute_CreateUsersJob] 75,1300768
CREATE PROCEDURE [dbo].[usp_Institute_CreateUsersJob]
    @InstituteBulkUserID INT,
    @InstituteID INT,
    @GradeID INT,
    @NoOfLearner INT,
    @NoOfInstructor INT,
    @UserPrefix NVARCHAR(50),
    @PasswordSalt NVARCHAR(100),
    @PasswordHash NVARCHAR(100),
    @UserName NVARCHAR(50)
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @process_id NVARCHAR(50),
            @datepart VARCHAR(8),
            @NewTimeSet VARCHAR(6),
            @cmd NVARCHAR(256),
            @DatabaseName NVARCHAR(100);

    SET @process_id = dbo.FNAGetNewID();
    SET @datepart = CONVERT(VARCHAR(8), GETDATE(), 112);
    SET @NewTimeSet = REPLACE(CONVERT(VARCHAR(8), DATEADD(SECOND, 10, GETDATE()), 108), ':', '');
    SET @DatabaseName = DB_NAME(DB_ID());
    SET @cmd
        = N'EXEC usp_Institute_CreateUsers ' + CAST(@InstituteBulkUserID AS NVARCHAR(50)) + N','
          + CAST(@InstituteID AS NVARCHAR(50)) + N',' + CAST(@GradeID AS NVARCHAR(50)) + N','
          + CAST(@NoOfLearner AS NVARCHAR(50)) + N',' + CAST(@NoOfInstructor AS NVARCHAR(50)) + N',''' + @UserPrefix
          + N''',''' + @PasswordSalt + N''',''' + @PasswordHash + N''',''' + @UserName + N'''';

    EXEC [dbo].[usp_core_process] '123',
                                  NULL,
                                  @process_id,
                                  NULL,
                                  NULL,
                                  1,
                                  @cmd,
                                  1,
                                  @DatabaseName,
                                  0,
                                  1,
                                  @datepart,
                                  @NewTimeSet;
END;