AnsweredAssumed Answered

OnTimer script with ExecuteSQL on hosted file

Question asked by sivagurS on May 31, 2018
Latest reply on May 31, 2018 by taylorsharpe


Hi

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.

 

Thanks

Outcomes