repro for post deployment soc issue.sql

/*
* Use this Post-Deployment script to perform tasks after the deployment of the project.
* Read more at https://www.red-gate.com/SOC7/post-deployment-script-help
*/
--This is terrible tsql, it's written for a quick repro only

DECLARE @name NVARCHAR(2000);

IF
(
    SELECT COUNT(*)
    FROM msdb.dbo.sysjobs
    WHERE name LIKE N'Test job created at%'
) > 0
BEGIN
    SELECT @name = name
    FROM msdb.dbo.sysjobs
    WHERE name LIKE N'Test job created at%';

    EXEC msdb.dbo.sp_delete_job @job_name = @name;
END;

SET @name = N'Test job created at ' + CAST(SYSDATETIME() AS VARCHAR) + N' by SCA';

EXEC msdb.dbo.sp_add_job @job_name = @name,
                         @enabled = 0,
                         @description = N'Testing job in post deployment script',
                         @owner_login_name = N'sa';
GO