i need something like a function to do a specific job which work in a specific time.Like every first day of the year i want to sum all the members account amount to my tbl_information table's column. How can i do that?
sfener06 0 Newbie Poster
nalply 0 Newbie Poster
When you open SQL Server Management Studio, you see SQL Server Agent. You can define jobs in the SQL Server Agent to be executed regularly at specified times.
kvprajapati 1,826 Posting Genius Team Colleague
Of course you may do so; Learn sql triggers,stored procedures, and functions.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.