Skip to main content
1 of 17
Java
  • 251
  • 2
  • 10

CmdExec not working in SQL Server 2019 as expected

I have been using SQL Server 2016's SQL Server Agent with bottom setting and script for last 3+ years. It was/is working fine.

enter image description here

But, now, I am migrating everything to SQL Server 2019, but the same command does not work.

So, I am wondering if there is anything that I have to modify (in terms of script) because of SQL Server 2019.

When I run the ps1 file itself, it works.

I also made sure everyone has a full control over the folders that are related.

Or if there is a way to use Powershell (instead of Operating system (CmdExec)) as "Type", what would be the script?

enter image description here

Java
  • 251
  • 2
  • 10