Member Avatar for sfener06

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?

  • 3 Contributors
  • 2 Replies
  • 62 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for nalply

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.

Member Avatar for kvprajapati

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.