i have written a program in c# language to update my scheduler table at 11:59 pm everyday. i configured my scheduler in DNN content management system to carry out the event every 11:59 PM. But the problem is each time the scheduler starts, it will continue to write or insect records multiple times in the scheduler table and will not stop unless i stop the scheuler manually. how can i fix the challenge? thanking you in anticipation.
These is exactly what am doing this.Progressing(); DashboardRecord(); //Calling the scheduler method
new DashboardController().DashboardUpdateTask(); //These is the class and method.
ctx.ExecuteSingleOrDefault(CommandType.StoredProcedure, "DashboardUpdateTask"); //Am calling a stored procedure here
inside my stored procedure is where am getting those information and insecting back to the scheduler table. Its working fine to these point.
even when i debuged, its insecting one record at a time.
but when i use the scheduler, once its time for the scheduler to insect into the scheduler table, it does it repeatedly and continuosly