c# - How to schedule a database task? -


background: created application measures weight scale , saves information in ms sql server database.

in database, want save record actual weight every day historical, , don’t know have use accomplish task.

can trigger in sql server ??

you don't need try , hack trigger. in sql server type of feature (scheduled execution) managed sql server job. just create sql server job runs once day , executes whatever t-sql need meet biz logic requirement.

so don't need code else. configure job , set schedule. not need application. sql server manages scheduled execution sql agent.

do note sql server jobs feature not available sql server express editions.


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -