• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

Scheduled tasks failing to run after 1st run

Hi,

We have a windows 2003 server setup and have been trying without success to get backup scheduled tasks to run, and now after testing, any scheduled tasks to run. Problem: when we setup any scheduled task (we are logged in as the administrator) e.g. to open Calculator it will run fine the first time it is supposed to run, and then the next day at that time it will fail. the logs have the following entry:

Calculator.job" (calc.exe) 5/24/2006 3:13:00 PM ** ERROR **
      The attempt to log on to the account associated with the task failed, therefore, the task did not run.
      The specific error is:
      0x80070569: Logon failure: the user has not been granted the requested logon type at this computer.
      Verify that the task's Run-as name and password are valid and try again.

We have definatly entered the correct username and password, which is valid as its the admin account we use to login tothe machine. We have recreated many test tasks - all fail in the same way after the 1st run. We have made the scheduled tasks service interact with desktop, the task properties to wake the machine.

Any help greatly appreciated.
0
cpearsona
Asked:
cpearsona
  • 3
  • 2
1 Solution
 
r-kCommented:
Try this:

Don't use the Control Panel to schedule your jobs. Instead, use the AT command from a command prompt.
It is quite easy to use, and some documentation is here:

  http://support.microsoft.com/default.aspx?scid=kb;en-us;313565&sd=tech

e.g. to schedule a bat file named backit.bat to run at 5:00 AM every morning, you would type:

        c:\> AT 05:00 /every:M,T,W,Th,F,S,Su c:\backup\daily.bat

See if this solves the problem.


   
0
 
Kevin HaysIT AnalystCommented:
I'm not sure if AT is in windows 2003 anymore.  I believe "schtasks" replaced it.  Why not run it under the system account instead of a regular account?

kshays
0
 
r-kCommented:
AT is still there, but schtasks should do the same thing. The main idea is to run it under the system account, which is what AT does by default.

(sorry about the typo in my example above, it schedules the file named daily.bat, not backit.bat, of course)
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
cpearsonaAuthor Commented:
cheers for the info - will be testing to day and know tomorrow. will keep you posted
0
 
cpearsonaAuthor Commented:
Hi all, have run the bat file via the AT command and it just results in the task status saying 'running' with the backup program not actually launching or completing the task, no matter how long it is left for. If i run the bat file manually it works as expected however.
0
 
r-kCommented:
It might be waiting for some user input, or some other error condition. The way to verify this is as  follows:

Create a second .bat file, say test.bat, and in that put just these two lines:

cmd /c "c:\backup\daily.bat" > "c:\backup\daily.log"
exit

(for example)

Then, schedule the test.bat file with the AT command. If it gets stuck, examine the daily.log file to see the results or reasons.




0

Featured Post

Industry Leaders: 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!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now