Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Reschedule a scheduled eventReschedule a scheduled event
Previous
 
Next
New Post
9/2/2007 10:23 PM
 

How do i change the time that an item in the scheduler runs?  We have installed a module that used a default time of 12:30 PM to run which slows down the system when it does.  We want to reschedule it for when traffic is slow on the site but can't seem to find anywhere to do that.  Please advise. 

 
New Post
9/3/2007 3:54 AM
 

Go to the host menu and then the SQL menu

Run the following script

SELECT     *
FROM         dnn_Schedule

Then you get the id of the schedule you need to modify.

Now you run the following script  to get the id of the record we need to modify

SELECT     ScheduleHistoryID, ScheduleID, StartDate, EndDate, Succeeded, LogNotes, NextStart, Server
FROM         dnn_ScheduleHistory
WHERE    ScheduleID = [Replace this with your scheduleID]
ORDER BY ScheduleHistoryID DESC

Now that we have this information you can run the following update script

UPDATE dnn_ScheduleHistory SET NextStart = [The date that it needs to be executed]
WHERE ScheduleHistoryID = [Your historyID]

You have to note that if your application restarts this can change things again. So there is no actual way of making a job at a specified time.
At my previous job I did this for a customer by running a stored procedure in the application start that would change the NextStart of the stored procedure.

 

 

 
New Post
9/3/2007 12:19 PM
 

You Rock! ... worked like a charm

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Reschedule a scheduled eventReschedule a scheduled event


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out