|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
time as a trigger
i need to check a table in my database to see if there has been no activity for a certain id within the last, say 30 minutes.
i know i can create triggers on insert or update of that table, but what if i want to check the data every 5 minutes. so that i don't have to rely on other users adding data to the table. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > time as a trigger |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|