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.

SQL Trigger will come this autumn.

---

Nice! 🙂

Excellent.

by SQL trigger du you mean oracle and Msssql?

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

---

Have I missed this feature. I would use it all the time!

We are working on it now.

---

You can test the new SQL Trigger here:

http://www.visualcron.co....aspx?g=posts&t=2811 

---