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


klewis10367
2012-09-11T13:52:16Z
Don't know if possible, but what would be a great option would be a SQL Database Trigger. My scenario would be where i have a sql view that is used to import invoice transactions into my ERP system....however when all invoices have been imported the view shows 0 records...what i would love is that a trigger could look at my view and based on the citeria i set..ie row count, dates..etc would kick off my job when met as the tables behind the view are updated by other processes. The way i handle it now is to run a job based on a time interval and use a condition to get row count and if 0 do not run job.
Sponsor
Forum information
Support
2012-09-11T13:54:57Z
SQL Trigger will come this autumn.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
osirisja
2012-09-11T14:19:02Z
klewis10367
2012-09-11T14:58:38Z
vistisen
2012-09-13T12:33:27Z
by SQL trigger du you mean oracle and Msssql?
Support
2012-09-13T12:37:13Z
Originally Posted by: vistisen 

by SQL trigger du you mean oracle and Msssql?




Any database server that is supported right now:


  • MSSQL (direct)
  • Oracle (direct)
  • MySQL (direct)
  • Any database through ODBC
  • Any database through OLEDB

Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
vistisen
2012-12-13T14:44:34Z
Have I missed this feature. I would use it all the time!
Support
2012-12-13T14:48:10Z
We are working on it now.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2012-12-14T15:54:00Z
You can test the new SQL Trigger here:

http://www.visualcron.co....aspx?g=posts&t=2811 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top