Description of the issue
I am calling the stored procedures for backups and index optimisation from broadcom automatic automation and it is stopping part way through
with return code 1
If I run the same command with the same user from ssms it runs and completes
SQL Server version and edition
Execute SELECT @@VERSION
Sql 2019 15.0.2000.5 (x64)
Version of the script
Check the header of the stored procedure
2033-12-03 17:23:44
What command are you executing?
Both indexoptimize and databasebackup so could be the commandexecution stored procedure
What output are you getting?
Output stops at command to run message
Description of the issue I am calling the stored procedures for backups and index optimisation from broadcom automatic automation and it is stopping part way through with return code 1 If I run the same command with the same user from ssms it runs and completes
SQL Server version and edition Execute
SELECT @@VERSIONSql 2019 15.0.2000.5 (x64)Version of the script Check the header of the stored procedure 2033-12-03 17:23:44 What command are you executing? Both indexoptimize and databasebackup so could be the commandexecution stored procedure What output are you getting? Output stops at command to run message