I need to run a script that calls multiple scripts on update a SQL database.
I run a query using Execute SQL script step, but when I run this script from Scheduled script from FM Server, I get the error Code 3 (Command not available).
Is Execute SQL compatible fro Scheduled script?
I am now calling this main script in an On timer Script - the script will take atmost 2 minutes to execute.
Is this an ideal way and how could I optimize this solution with scheduled scripts.