SQL Trigger being Inactivated - VisualCron - Forum

Community forum

klewis10367
2013-08-13T11:40:56Z
I am using a SQL Trigger that is getting inactivated at random times. The SQL Server and the SQL Services are not being restarted or rebooted as they are attached to a live environment. There is no expiration enabled. Any ideas? I know it is not a lot of information to give. Version 7.0.3. I do not see any log file that would help me.
Support
2013-08-13T11:54:27Z
Ok, what about increasing Retry times on error?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2013-08-13T16:31:45Z
There is no retry option for the SQL Trigger.
Support
2013-08-14T08:25:19Z
You are right. We probably need to implement that. I am moving this topic to Feature requests.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2013-08-14T11:57:50Z
Thanks...in the mean time i changed the command timeout from the default 0 to 600...who knows...i will update if seems to work.
klewis10367
2013-09-11T19:07:11Z
Just an update...i am on Version 7.0.5 latest beta and this inactivation has seemed to go away. In the previous reply i had stated i changed the command timeout...this did not fix the inactivation issue either in the older versions.
Scroll to Top