Scheduled Jobs don't run when creator not logged on.

[Allan]

Hi,
I'd appreciate any advice on the following issue. I have
set up a scheduled job that runs an excel program with
Macros. It runs perfectly when I am logged on, but when I
am not it starts OK but stays in a "running" status and
does not end. There is no indication in the SchedLgU file
as to the cause of the issue.

All the profiles are members of the Administrator group.

Any suggestions would be appreciated.

 

[Roger Abell]

Have you asked in an Excel newsgroup ?
Scheduled tasks are intented for things that can
run without a user interface. Is this how you are
invoking Excel to execute the macros ?

 

[Guest]

Thanks for the response Roger.
No user interface necessary. This Workbook runs a macro on
opening to collect some data from an Oracle database, then
saves itself and closes.
It worked fine under Windows NT, always ran if owner was
logged on, another user was logged on, or no user was
logged on. Now it only runs when the 'run as' user is
logged on. If another user or no user is logged on it
starts but stays in a 'running' status.

Allan

 

[Roger Abell]

I still think I would try asking over in an Excel oriented
newsgroup. It sounds, by what you have said, for all the
world like it is wanting to be able to access something in
a winstation (desktop) of that account, which only exists
if the account is logged in interactively.
It does not matter what account (with sufficient permissions
for the task) is used, right? I mean a fresh account with
minimal change to it to allow the task is also not able to
run it as a scheduled task in absence of login. The idea
here is that there is something in the customizations of that
account you have been trying that impact how Excel engine
tries to run this.