automatic stored procedure or trigger
-
is it possible ,on every 00 hrs a stored procedure or trigger fire automatically to update certain values of atable automatically.
-
This is normally solved by a stored procedure that is executed from a scheduler daily at 00hs.
Habetis bona deum
-
The schedule runs in the database server, so the type of application does not matter. For example if you database is MS SQL Server 2000 on Windows Server you create the stored procedure in the database. Then go to Enterprise Manager->[You SQL Server Group]->[You Database]->Administration->SQL Server Agent->Jobs Right Click -> add New Job: Enter a name go to tab steps-> New: Enter a name Select -> Transact SQL Command (or something like) Fill in the sp call Go to the next tab Click New Schedule Click Change Select daily Set the desired time Accept all dialogs Hope it helps
Habetis bona deum