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


GDever
2017-09-19T14:29:54Z
I would like to capture messages from my tsql stored procedure somehow in VisualCron. It would be convenient to have the messages sent to a second standard output maybe called “message output” and visible in the job log. Or, I’d like to have the option for messages to go to standard output with the result sets, but this option would need to be off by default.

Sponsor
Forum information
Support
2017-09-29T15:03:52Z
This has now been added in latest beta. https://www.visualcron.c....aspx?g=posts&t=7604 

Both as an option in SQL output and as a Variable;

infomessage.png
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
GDever
2017-09-29T20:08:06Z
Wow, great to hear. One question, will the output window update as the messages are sent or at the end of the task? It would be nice to see the messages as the task progresses. Sometimes I use "RAISERROR('My Message Text",0,1) WITH NOWAIT" to output messages to show progress. Either way this feature will be useful. Thank You!
Support
2017-09-29T21:29:38Z
Originally Posted by: GDever 

Wow, great to hear. One question, will the output window update as the messages are sent or at the end of the task? It would be nice to see the messages as the task progresses. Sometimes I use "RAISERROR('My Message Text",0,1) WITH NOWAIT" to output messages to show progress. Either way this feature will be useful. Thank You!



It will be before the execution as the messages are received before we fill the dataset with data.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2017-09-30T08:09:01Z
Update. In next build we will fix so that messages can come during query.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
GDever
2017-10-02T13:28:29Z
Scroll to Top