Solved

scheduler on windows

Posted on 2011-03-08
7
317 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
  • 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Checkbox Notification 3 23
Thanks for the advise, but... 4 24
Manipulate Data Quickly 2 13
Excel 2016 Hiding Toolbars 7 22
A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now