How can i update/insert/delete in a table using trigger or SP using system clock. Like every end of the month or every friday a table is updated using a query. thanks

__________________
Proud To Be Pinoy

In Windows I know you can make Scheduled Tasks in the Control Panel. I don't know about other OS's.

HTH,

Snib

<><

i think the best solution is to create a SQL Server Agent job. the job can be configured to run at certain time intervals. the job could have only one step that calls a sp that does the things you want to be done.