开发者

How to fire trigger at the end of the month?

开发者 https://www.devze.com 2023-03-13 16:40 出处:网络
I want to know how 开发者_C百科to fire trigger at the end of the month in MSSql . Regards, Giri BhushanINSERTs and UPDATEs and DELETEs fire triggers. Not schedules.

I want to know how 开发者_C百科to fire trigger at the end of the month in MSSql .

Regards, Giri Bhushan


INSERTs and UPDATEs and DELETEs fire triggers. Not schedules.

You'd set up a job in SQL Server Agent to run a stored procedure or some SQL when needed. Or some external scheduler (Windows scheduler, Quartz.net etc) to run some SQL code.

0

精彩评论

暂无评论...
验证码 换一张
取 消