OK. Sorry I do not use SQL hardly ever.
I think this what you are using...
https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-cmdexec-job-stepThis topic describes how to create and define a Microsoft SQL Server Agent job step in SQL Server 2017 that uses an executable program or operating system command by using SQL Server Management Studio, Transact-SQL or SQL Server Management Objects.
The rename command in Windows 7 CMD does not have an explicit insert operator. But I think it allows you to rename a file with a longer name.
(For simplicity, I will not use paths and extensions in the examples.)
Say I have wanted five files named:
ass0
ass456
ass4567
ass45678Plus three files a little different in the current directory
asw456
aws0
aqs456I can use this to see of the first three letters identify the files I want
DIR äss* /b (Forum rules require me to use äas instead of *censored*.)Yes, it shows only the five files, not the others.
Now I rename using
rem äss* Sass*
(Change
ä to
a in above.)
That will insert the letter S at the start of each name.
Is that what you want?