Home > IT Answers > Development > Daily trigger in SQL
Barend IT
15 pts.
 Daily trigger in SQL
SQL, Triggers
I'm trying to create a trigger to execute daily and calculate a few averages for me. Please help!

Software/Hardware used:
ASKED: March 13, 2008  6:50 AM
UPDATED: March 13, 2008  1:08 PM
RELATED QUESTIONS
Answer Wiki:
This would be a stored procedure not a trigger. You can not schedule triggers to run on a schedule. Create a stored procedure with the code needed to calculate the averages and then use the SQL Server Agent to schedule the stored procedure to run nightly.
Last Wiki Answer Submitted:  March 13, 2008  10:26 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.