Scheduled Jobs during hours of autumn time change

Posted by NealWalters on Server Fault See other posts from Server Fault or by NealWalters
Published on 2013-10-30T20:19:30Z Indexed on 2013/10/30 21:58 UTC
Read the original article Hit count: 287

Filed under:

scheduled-task

|

task-scheduler

|

job-scheduler

|

sqlagent

I'm wondering how other people deal with this scenario.

What if you have a job scheduled to run at 1:30 am. In the autumn, when time changes, the hour of 1:00:00 to 1:59:59 repeats itself and so that job would run twice.

Could be Windows Task Scheduler, SQL Agent or any other scheduling tool. Most of these tools seem to be based on machine time, not UTC time. If I told it to run the job at UTC time each night, then I wouldn't have the duplicate hour issue.

© Server Fault or respective owner

Related posts about scheduled-task

Running a scheduled task as SYSTEM with console window open

as seen on Server Fault - Search for 'Server Fault'
I am auto creating scheduled tasks with this line within a batch windows script: schtasks /Create /RU SYSTEM /RP SYSTEM /TN startup-task-%%i /TR %SPEEDWAY_DIR%\%TARGET_DIR%%%i\%STARTUPFILE% /SC HOURLY /MO 1 /ST 17:%%i1:00 I wanted to avoid using specific user credentials and thus decided to use… >>> More
Windows 2008 R2 Scheduled Task Not Running With Admin Privileges even if granted?

as seen on Server Fault - Search for 'Server Fault'
I have a scheduled task that is running as USER. I have checked the box "Run with highest privileges" in the scheduled task properties. The task is a powershell script that, among other things, reboots the system. The script executes and runs normally, but as a scheduled task, it fails to reboot… >>> More
Update password for scheduled task

as seen on Server Fault - Search for 'Server Fault'
I have a scheduled task that needs to run as a service account. The service account's password resets every 100 days, so I need to update the password for the scheduled task. I cannot figure out how to do this. When I select "Change User or Group" in the scheduled tasks' properties I get no prompt… >>> More
How can I get a scheduled task to run for a user regardless of which computer the user is logged onto?

as seen on Server Fault - Search for 'Server Fault'
I've got a scheduled task that needs to run for a user at a specific time. However, the user sometimes logs onto one machine, the next day onto another, then next week onto yet another. At some pint during the day, the user might have to log onto another machine. How do I get the scheduled task to… >>> More
Add Scheduled Task to reset search indexes for Exchange 2007

as seen on Server Fault - Search for 'Server Fault'
I simply want to run a ResetSearchIndex -force on a schedule. What is the correct usage for the command in the Scheduled Task properties? It seems I would first need to start Powershell, then load the console file or snap-in for Exchange, which one of these is the closest: C:\WINDOWS\system32\WINDOW~2\v1… >>> More

Related posts about task-scheduler

Task scheduler "hidden" only hides task, not process

as seen on Server Fault - Search for 'Server Fault'
I am trying to make an application that acts like a desktop application for all the computers in our network. I have already got a windows forms app that works like I want it to, and I'm using the task scheduler to start it on login. We would really like it if the process as well as the task is… >>> More
Parallelism in .NET – Part 15, Making Tasks Run: The TaskScheduler

as seen on Reed Copsey - Search for 'Reed Copsey'
In my introduction to the Task class, I specifically made mention that the Task class does not directly provide it’s own execution. In addition, I made a strong point that the Task class itself is not directly related to threads or multithreading. Rather, the Task class is used to implement… >>> More
Defragment / Performance Monitor without Task Scheduler

as seen on Server Fault - Search for 'Server Fault'
My organisation has a policy of disabling Task Scheduler on all servers and workstations (don't ask, I tried once to wrestle the pig). I need to collect performance stats using Data Collector Sets in Windows 7 or Windows 2008 but the Performance Monitor interface requires Task Scheduler to be running… >>> More
Task Scheduler not able to execute .vbs scripts successfully

as seen on Server Fault - Search for 'Server Fault'
Apologies if this has a really obvious answer! We have several daily tasks we run via a .vbs script on our server (through the Task Scheduler), and for months it has been fine, but recently we've hit a problem. The .vbs scripts stopped successfully executing (always timing out)... but could still… >>> More
Open Web Page in Windows 2008 R2 Task Scheduler runs forever

as seen on Server Fault - Search for 'Server Fault'
I have a number of scheduled tasks which simply open a web page in Windows Server 2008 R2. They used to run and end without abending, but now they open and stay open and I have to setup the task to quit them by force before their next scheduled run. I've thought about installing CURL or WGET, but… >>> More