How to Insert Summary Info in a table at midnight everyday?

microsoft.public.sqlserver.tools

18 Oct 2006 2:05 AM

rabig

I have to populate a summary table everyday.
Need to count the number of (STATUS =)'Opened', 'Testing', 'Closed' and
'Pending' from the Cases table and INSERT these values into the
'Summary' Table at 10:00 PM everyday.
How do I schedule an Auto INSERT? Any help will be greatly appriciated

18 Oct 2006 2:23 AM

Andrew J. Kelly

You can simply schedule a job using the SQL Agent job scheduler. Look in
BooksOnLine for more details on scheduling or SQL Agent.

--
Andrew J. Kelly SQL MVP

Show quote

"rabig" <ra***@yahoo.com> wrote in message
news:1161137144.561928.202420@i3g2000cwc.googlegroups.com...
>I have to populate a summary table everyday.
> Need to count the number of (STATUS =)'Opened', 'Testing', 'Closed' and
> 'Pending' from the Cases table and INSERT these values into the
> 'Summary' Table at 10:00 PM everyday.
> How do I schedule an Auto INSERT? Any help will be greatly appriciated
>