DECLARE @FILE_NAME VARCHAR(8000) = N'my-file' + '_' + CAST(CAST(GETDATE() AS DATE) AS VARCHAR(10))
EXEC send_zip_existing_file
@7ZIPEXE_PATH = N'C:\sql_attach\zip_util\7-Zip\7z.exe',
@SOURCE_PATH = N'C:\sql_attach\csv_file\my-file*',
@DEST_DIR = N'C:\sql_attach\csv_file\',
@DEST_FILE = @FILE_NAME,
@EMAIL_PROFILE = N'Default',
@EMAIL_TO = N'to@email.com',
@EMAIL_REPLY = N'reply@email.com',
@EMAIL_BCC = N'bcc@email.com'