HomeForum
Welcome, Guest

Task Scheduler repeatedly runs scheduled job
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Task Scheduler repeatedly runs scheduled job

Task Scheduler repeatedly runs scheduled job 1 year, 12 months ago #780

  • ddudley20
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Running VI Ent. Edtn. on PC and app server. Built package on PC, tested, syncronized to server, tested, Package works great. Built Scheduled Task to run once per day at midnight. And yes, I'm 100% sure it is scheduled correctly to run daily, not by minute.
Problem - Scheduled task runs fine, but over and over again. Restarted app, deleted and recreated the Task, disabled and reenabled task, no resolve. Set to run once daily at 9am let's say, by 9:30am it has rerun for the 12th time. Even set the schedule not to start until next day, yet reruns repeatedly. Had this problem last month with my first Scheduled Task, believe it stopped running the next day after rerunning about 180+ times and true run time had passed. Not remembering for sure.
Anyone have an idea how to resolve?

Update - found solution, schedule job for current day and x number of minutes in the past. Example = enable scheduled task for today 2/11, and at 10:00am if time is now 10:10am. The jobs sits quitely until tomorrow 2/12 and will run once at 10:00am. Problem is I have to get up at midnight to schedule it for 23:59:00 hrs.

Re:Task Scheduler repeatedly runs scheduled job 1 year, 12 months ago #781

  • admin
  • OFFLINE
  • Moderator
  • Posts: 1934
  • Karma: 11
Execution timer is running every minute
It checks schedule table and if there is something to execute it executes it
Than it updates relevant record with next execution date/time.
If schedule table is locked or corrupted the update will fail and the package would be executed every minute

I guess you are using default MS Access Repository.
Clear the log and compact and repair the database in ms access
It should help you with the problem

Mike
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

We found Advanced ETL Processor remarkably easy to use and DBSL support team provides outstanding value and service.

David Thomson
Marketing Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top