Make start field static

Hello

Would it be possible to make the start time static at all rather than show the last time it was executed?

The reason I ask is that if the server has a problem, it stops running next time if the next time it's due to run is at 12am.

or would it be possible in the interim to send me s scrip that will set all the start times for all packages to 00:00:01 as all of them run every few minutes?

Good Morning

Would it be possible to make the start time static at all rather than show the last time it was executed?

It is not "the last time it was executed" is "the time of next execution"

Let say we run something every five minutes

Current time is 2021-10-05 12:03:00'
Start time is 2021-10-05 12:05:00'

We run the following SQL.

select count(*) from schedule where start_time < current

SQL returns zero = we have nothing to execute

Let say the current time is 2021-10-05 12:05:03'

The same SQL returns 1
so we execute the package and set the start time to 2021-10-05 12:10:00'

And so on.

All schedule settings are stored in [SCHEDULE] table

You can update START_AT for all records by running the following SQL

Update [SCHEDULE] set START_AT='2021-10-05 00:00:01'

Here is the list of repository tables.

www.etl-tools.com/wiki/knowledgebase/repository_tables

I hope you will find my comments useful

Ah, I see I think what's happening is the job fails just after midnight so the next execution is stuck on 23:57 so the next day it won't execute till 23:57 by that point a day has passed.

I'll write a SQL agent to run periodically to update the start time in the table

many thanks

Yes, it is technically possible in case of server failure.

It should change 'start at' to next day 2021-10-06 00:02:00'

I will double-check it here