Start of Day and End of Day Process

[yameen2011]

Hi guys.
In my database i need two process in the database one is SOD(Start of Day) and the 2nd one is EOD (End Of Day).
The purpose of these process to run multiple hidden queries in back-end. In both processes there are several queries to run.
I need help to setup this.i have no idea that how i can built this but this is necessary for database.
another thing these process execute only once a day.
after login i want to run a form that will check that SOD is performed or not if not then SOD (Run SOD) Screen will appear if SOD not perform yet then system ask for SOD Process to run otherwise disable my dashboard items.
and 2ndly if EOD not performed last day then system will run normally and not ask for SOD process.
If any one understand, please help me.

 

[MarkK]

This requirement seems to me to result from poor table design. Data should be stored raw, not processed. If you need to process data prior to presentation, do so just prior to presentation, not at fixed points in time.

I would recommend that you find a way to store your data that it doesn't need such fragile intermediate processing steps. So rather than ask how to perform those steps, ask how NOT to.

 

[yameen2011]

This requirement seems to me to result from poor table design. Data should be stored raw, not processed. If you need to process data prior to presentation, do so just prior to presentation, not at fixed points in time.

I would recommend that you find a way to store your data that it doesn't need such fragile intermediate processing steps. So rather than ask how to perform those steps, ask how NOT to.

Dear MarkK thanks for having look on my thread, for you information I have a good structured database where tables are not holding raw data. Everything is on its own place. I don’t have to need to process data before presentation. But if you have any ideas about my question then help me for solution.
That I want to Run SOD before start working on database, Before SOD no any user not allowed to use the database, And same for EOD after Running EOD no user is allowed to use and working on software, these are my requirements and2nd one is that after EOD my daily transaction tables are refreshed and data appended to the General_ Journal table where all the transactions are located.
Thanks.

 

[MarkK]

Why is this true?

Before SOD no any user not allowed to use the database

That, in my opinion, is a design problem. I would never seek to refine that dependency/vulnerability, I would seek to eliminate it.

 

[gemma-the-husky]

all you can do is set a control flag in a table to indicate the last date this process was performed. (say)

test this on startup and react accordingly

there is always a problem with things like this of the flag not being set correctly - eg in the event of the database exiting abnormally - so you need an override somehow in the event of this sort of issue arising.