Solved

scheduler on windows

Posted on 2011-03-08
7
324 Views
Last Modified: 2012-08-14
Hi

I am trying to set a excel sheet to run on a particular time of the day. I have set it on the Scheduled Task on my computer. If I choose the task and hit run, it will run. But it will not do a scheduled run.
"Run only if logged on" is deselected - so I don't think it is not running because I am not logged in all the time.

What could be causing this scheduled task not to run?

thanks
0
Comment
Question by:LuckyLucks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35069966
This might be a permission issue. Is your computer connected to a network?

Sincerely,
Ed
0
 
LVL 5

Expert Comment

by:wellous
ID: 35072135
Is the Task Scheduler service set to Automatic and running?

Open Services...
Start | Run | Type: services.msc | Click OK |
Scroll down to and double click Task Scheduler |
Make sure that it's set to Automatic under Startup type |
Click the Start button | When it starts, close Services

Open the SchedLgU.txt and see what you can see.

Start | Run | Type: SchedLgU.txt | Click OK

C:\WINDOWS\SchedLgU.txt

Or, Open Scheduled Tasks.
On the Advanced menu, click View Log.

From XP HELP:

Troubleshooting Scheduled Tasks
[[If a scheduled task does not run when you expect it to, right-click the
task, and then click Properties. On the Task tab, verify that the Enabled
check box is selected. On the Schedule tab, verify that the schedule is set
correctly.

If a task program does not run correctly, you might need to add command-line
options to the path of the program. For more information about a particular
program and its command-line options, try one of the following:

* If available, view Help for the program.
* At a command prompt, type the following (where program is the name of the
task program you are trying to run): program /?

You can also check the Status column in the Scheduled Tasks window. The
following table describes the status types.

Status Description
Blank The task is not running, or it ran and was successful.
Running The task is currently being run.
Missed One or more attempts to run this task was missed.
Could not start The most recent attempt to start the task failed.

For more information about the status of a scheduled task, you can check the
SchedLgU.txt log file. This log file for Scheduled Tasks is stored in the
Windows folder, where it is used to record the activity of scheduled tasks.
You can use the log file to determine why a task might have stopped, or to
check on the status of a task.

Notes
* If you cannot run any scheduled tasks on your computer, and your computer
is connected to a domain, see your system administrator to make sure that
the Scheduled Tasks service is turned on.
* If a user is not logged on at the time the task is scheduled to run, the
task runs, but it will not be visible.
* To check the status of a scheduled task, on the View menu, click Details,
and then scroll to view the Status column.]]

The Task Scheduler service can also be stopped from the Scheduled Tasks
window.

"The Task Scheduler service must be running and properly configured to run
tasks. If you had stopped scheduled tasks manually from the Scheduled Tasks
window, the service stops and does not initialize the next time you start
the computer."

"Check your task scheduler - change the security on the job so it matches
your account name and password."
Lanwench [MVP - Exchange]

"The accounts database may be corrupt. Try deleting all tasks then after
restart add them back in."
Dave Patrick MS-MVP

How to troubleshoot scheduled tasks in Windows XP and in Windows Server 2003
http://support.microsoft.com/kb/308558

--
Hope this helps.
Brgds
Wellous
0
 

Author Comment

by:LuckyLucks
ID: 35200053
what does it mean when the Status is "Could not start" but the last result column shows 0x0 ie The operation completed successfully ? Isn't 0x0 supposed to be for a sucessful run?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Expert Comment

by:wellous
ID: 35202209
Definitely you have issues here ..
Are you the Admin ? if not ? then you can ask your Admin to enable it for you.
The status should be "Started" . nothing else.
If you are the Admin , then you need more troubleshooting to Enable the service Automatically.

GL,
Wellous
0
 

Author Comment

by:LuckyLucks
ID: 35281949
I am not the admin, neither am I running the task as an admin. However, I am confused that it actually runs but logs the status as "Could not start".

the log seems to say this:
      Started 3/20/2011 8:05:03 AM
      Started indirectly, through a shortcut; task finish will not be logged.

In the Run section, I list the full path to the excel file A:\.....\blah\blah.xlsm
and in the Start in:, I list A:\.....\blah



0
 
LVL 5

Accepted Solution

by:
wellous earned 500 total points
ID: 35296728
Hi,

Here is the issue,
[[[[ In the Run section, I list the full path to the excel file A:\.....\blah\blah.xlsm
and in the Start in:, I list A:\.....\blah ]]]]]

In the start in , you have to list the shortcut of Microsoft Excel ink ...
ex. "C:\Documents and Settings\All Users\Start Menu\Programs\Office\Microsoft Office Excel 2003.lnk"

Please give it a try and tell me, i already tested it ...
and regarding the status , it should be blank all the time .. and to be Running while running the task.

GL,
Wellous
0
 
LVL 5

Expert Comment

by:wellous
ID: 35305061
Glad to help,
Thanks for the grade :)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question