question

dekolaguy avatar image
dekolaguy asked

create a control log table and also a count history log

Hello I am trying to create control log table and a history log table as well . I have attached what I want the table to look like. -Job number would be a generic number that would be created for each job -Job Name is the tables that count of daily records -Run Gap is the time of the last run to the latest run sql statement might be (select count (*) from PDM.dbo.recipient where DateTimeCreated between Getdate-# run gap and getdate() )![alt text][1] -Lastrun time The second table would be the job runs history which would capture Job Number - Time run - which would be timestamp for hours in a day running from 00:00 to 21:00 hours count of records in each hour thanks find attached [1]: /storage/temp/4564-capturereporting.jpg
sql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.