July 9, 2014 at 9:20 am
Hi,
I want to write sql query which runs in a background on cyclic basis. Basically i want to count the row entries of 1 table and store the data and the count in two distinct columns.
please help.
regards,
Bilal
July 9, 2014 at 10:41 am
Sounds like you want to put a query in a SQL Agent Job which will allow you to schedule the execution for whatever frequency you need.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 10, 2014 at 7:48 am
Hi,
PLEASE CAN ANYONE HELP ME IN THIS....AS I AM NEW TO MS SQL
rEGARDS,
BILAL
July 10, 2014 at 8:00 am
bilal 17797 (7/9/2014)
Hi,I want to write sql query which runs in a background on cyclic basis. Basically i want to count the row entries of 1 table and store the data and the count in two distinct columns.
please help.
regards,
Bilal
You need to create SQL Agent Job. You can use SSMS or T-SQL script to create the job.
Refer http://msdn.microsoft.com/en-IN/library/ms190268.aspx for more details.
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply