SQL 2025 Jobs

Hello

Hello

Many tests performed.

I created two independent tasks do type (T-SQL) , each calling one of the two Store procedures. They failed.

I executed then the Store procedures directly and saved each generated SQLquery in two SQL files.

I created two tasks, each with a step of the type (operating system - (cmdexec) and with the command = sqlcmd -S XXXXX -i ".......................file.sql") --- It works.

I ran lab on another machine, running Windows 11 Pro and also with SQL 2022 Standard.

I created the database in question and restored it from a recent backup.

Everything worked exactly as described above, even when I set a Windows account to start the agent service.

This database was on a server running SQL Standard 2017 and Windows Server 2012. Now it's on SQL 2022 Standard running on Windows Server 2025vStd.

I'm clueless!