It would appear your description got lost upon posting. I'd be happy to address any questions you have about Events and the EventArchive table, however. Simply add them to your reply and I'll do my best to provide meaningful insights.
Thanks,
Ryan
Hello Ronnie,
It would appear your description got lost upon posting. I'd be happy to address any questions you have about Events and the EventArchive table, however. Simply add them to your reply and I'll do my best to provide meaningful insights.
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
Best Regards,
Ronnie Abrahiem
Sr. Programmer Analyst - Yellowfin Administrator
North American Information Technology Services
DENSO International America, Inc.
ronnie_abrahiem@DENSO-diam.com
Tie: 5000-3460
Office: 248.750.3460
Fax: 248.213.2469
/icons/expand.gif
Event and EventArchive table
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
Thanks for reaching out with your question. Your Event table contains records for April 2017, as none of these tasks have surpassed the 30 day time frame to be moved into your EventArchive table. These will remain in the Event table until after 30 days has passed since the job has completed. You shouldn't see any records newer than 20 MAR, 2017 in the EventArchive table until they are moved from your Event table. Can you verify that you have no records from 21 MAR, 2017 - 22 MAR, 2017?
Please provide the results of the following queries:
SELECT EventDate FROM Event;
SELECT EventDate FROM EventArchive;
Please include the results in a file of your preference, i.e. txt, csv, etc.
Thanks,
Ryan
Hi Ronnie,
Thanks for reaching out with your question. Your Event table contains records for April 2017, as none of these tasks have surpassed the 30 day time frame to be moved into your EventArchive table. These will remain in the Event table until after 30 days has passed since the job has completed. You shouldn't see any records newer than 20 MAR, 2017 in the EventArchive table until they are moved from your Event table. Can you verify that you have no records from 21 MAR, 2017 - 22 MAR, 2017?
Please provide the results of the following queries:
SELECT EventDate FROM Event;
SELECT EventDate FROM EventArchive;
Please include the results in a file of your preference, i.e. txt, csv, etc.
1. SELECT EventDate FROM Event; The table start with 26-MAR-17
2. SELECT EventDate FROM EventArchive; The table start with 20-MAR-17 but when I ran
Select * from EVENTARCHIVE where EVENTDATE between '21-MAR-17' and '21-MAR-17'; the table start with
21-MAR-17.
Is that means the "EventArchiveTask" in Taskschedule table run every day and remove the records from Event table to Eventarchive table then delete the records from Event table.
Thanks
Ronnie A.
Hello Ryan,
Thank you for your support.
1. SELECT EventDate FROM Event; The table start with 26-MAR-17
2. SELECT EventDate FROM EventArchive; The table start with 20-MAR-17 but when I ran
Select * from EVENTARCHIVE where EVENTDATE between '21-MAR-17' and '21-MAR-17'; the table start with
21-MAR-17.
Is that means the "EventArchiveTask" in Taskschedule table run every day and remove the records from Event table to Eventarchive table then delete the records from Event table.
You are correct, the "EventArchiveTask" should run daily to add the records to EventArchive and then delete the original entries in the Event table. If the table included 21-MAR-17, I'd venture to say that the task is properly moving the records over. You can verify that 25-MAR-17 exists in your EventArchive table to be sure. The date your Event table starts with is exactly 30 days ago, so that part seems to be working great!
Double-check your EventArchive table for anything dated 25-MAR-17 and you'll know that the records are being moved properly.
Thanks,
Ryan
Hi Ronnie,
You are correct, the "EventArchiveTask" should run daily to add the records to EventArchive and then delete the original entries in the Event table. If the table included 21-MAR-17, I'd venture to say that the task is properly moving the records over. You can verify that 25-MAR-17 exists in your EventArchive table to be sure. The date your Event table starts with is exactly 30 days ago, so that part seems to be working great!
Double-check your EventArchive table for anything dated 25-MAR-17 and you'll know that the records are being moved properly.
You are correct. With the settings you've provided, the records will be deleted after their date reaches 60 days. I'm happy I was able to offer some insight here. If you have any further questions or issues, don't hesitate to let us know!
Thanks,
Ryan
Hi Ronnie,
You are correct. With the settings you've provided, the records will be deleted after their date reaches 60 days. I'm happy I was able to offer some insight here. If you have any further questions or issues, don't hesitate to let us know!
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
Best Regards,
Ronnie Abrahiem
Sr. Programmer Analyst - Yellowfin Administrator
North American Information Technology Services
DENSO International America, Inc.
ronnie_abrahiem@DENSO-diam.com
Tie: 5000-3460
Office: 248.750.3460
Fax: 248.213.2469
/icons/expand.gif
Event and EventArchive table
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
The same question
Hello Ronnie,
It would appear your description got lost upon posting. I'd be happy to address any questions you have about Events and the EventArchive table, however. Simply add them to your reply and I'll do my best to provide meaningful insights.
Thanks,
Ryan
Hello Ronnie,
It would appear your description got lost upon posting. I'd be happy to address any questions you have about Events and the EventArchive table, however. Simply add them to your reply and I'll do my best to provide meaningful insights.
Thanks,
Ryan
Event and EventArchive table
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
Best Regards,
Ronnie Abrahiem
Sr. Programmer Analyst - Yellowfin Administrator
North American Information Technology Services
DENSO International America, Inc.
ronnie_abrahiem@DENSO-diam.com
Tie: 5000-3460
Office: 248.750.3460
Fax: 248.213.2469
/icons/expand.gif
Event and EventArchive table
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
Best Regards,
Ronnie Abrahiem
Sr. Programmer Analyst - Yellowfin Administrator
North American Information Technology Services
DENSO International America, Inc.
ronnie_abrahiem@DENSO-diam.com
Tie: 5000-3460
Office: 248.750.3460
Fax: 248.213.2469
/icons/expand.gif
Hi Ronnie,
Thanks for reaching out with your question. Your Event table contains records for April 2017, as none of these tasks have surpassed the 30 day time frame to be moved into your EventArchive table. These will remain in the Event table until after 30 days has passed since the job has completed. You shouldn't see any records newer than 20 MAR, 2017 in the EventArchive table until they are moved from your Event table. Can you verify that you have no records from 21 MAR, 2017 - 22 MAR, 2017?
Please provide the results of the following queries:
Please include the results in a file of your preference, i.e. txt, csv, etc.
Thanks,
Ryan
Hi Ronnie,
Thanks for reaching out with your question. Your Event table contains records for April 2017, as none of these tasks have surpassed the 30 day time frame to be moved into your EventArchive table. These will remain in the Event table until after 30 days has passed since the job has completed. You shouldn't see any records newer than 20 MAR, 2017 in the EventArchive table until they are moved from your Event table. Can you verify that you have no records from 21 MAR, 2017 - 22 MAR, 2017?
Please provide the results of the following queries:
Please include the results in a file of your preference, i.e. txt, csv, etc.
Thanks,
Ryan
Event and EventArchive table
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
Best Regards,
Ronnie Abrahiem
Sr. Programmer Analyst - Yellowfin Administrator
North American Information Technology Services
DENSO International America, Inc.
ronnie_abrahiem@DENSO-diam.com
Tie: 5000-3460
Office: 248.750.3460
Fax: 248.213.2469
/icons/expand.gif
Event and EventArchive table
1. In Configuration table I insert the following job:
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
insert into Configuration VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
2. In Taskschedule table has one record for ‘EventArchiveTask’ setup as ‘DAILY’ 1, SYSTEMTASK,EventArchiveTask,0,1,AMERICA/NEW_YORK,DAILY,0,20170420040030,20-APR-17,14430,SUCCESS,0
My question; why in Event table I have records for April 2017 and I don’t have any April’s records in EVENTARCHIVE table.
The Event table currently has records only between 20 APR, 2017 and 20 MAR, 2017. This table looks okay because set up for > 30 day.
The Eventarchive table currently has records only between 01 Jan, 2017 and 20 MAR, 2017. This table it seems missing records and not archived.
What I understand that “There are 2 jobs that are important to this upkeep and maintenance of the Event and EventArchive tables, one of them moves records from the Event table to the EventArchive table when they become older than a certain number of days, and the other one deletes records from the EventArchive table when they become older than a certain number of days. The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.”
Best Regards,
Ronnie Abrahiem
Sr. Programmer Analyst - Yellowfin Administrator
North American Information Technology Services
DENSO International America, Inc.
ronnie_abrahiem@DENSO-diam.com
Tie: 5000-3460
Office: 248.750.3460
Fax: 248.213.2469
/icons/expand.gif
Replies have been locked on this page!