Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Yaroslav
2014-01-27T10:20:32Z
I'm trying to execute a tsql code on a database task. The tsql code executes without any issue on the SSMS. But when manually testing the task from VisualCron I get this error:

Quote:

Error in SQL query: Must declare the scalar variable "@xxxx".
Exception in Task: Must declare the scalar variable "@xxxx"



What else do I need to do? I thought that the tsql code will be fully executed on the database engine, so no need to declare any variables on task creation. Thanks.
Sponsor
Forum information
Support
2014-01-27T10:33:35Z
Are you using using SQL Text or Stored procedure option?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Yaroslav
2014-01-27T10:48:13Z
I'm using SQL Text. I found what was triggering the error. The check box "Split and run multiple queries with semicolon as separator" was checked. Unchecked and now it's ok. Thanks.
Support
2014-01-27T10:48:57Z
Great, thanks for the update.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top