Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Microsoft SQL Server 2008: Task Scheduler (Last Time Run: not displaying?)

Reply
Thread Tools Display Modes

Microsoft SQL Server 2008: Task Scheduler (Last Time Run: not displaying?)

 
 
Microsoft SQL Server 2008: Task Scheduler
Guest
Posts: n/a

 
      05-19-2011
I am working on a 2008 Sql Server in which has Batch File set up to
run.
The Task Scheduler "Last Run Time" does not show any history for the
scripts I have set up? I looked at my scripts and do not understand
why Task Scheduler is not updating as needed. Task Scheduler should
be creating a history log on this script?


The scripts details are as follows:

@echo off
REM
REM This script stops the Xpress Server for the Integrity check SQL
JOb
REM to run sucessfully



set LOGGING=d:\xps\upload\keep1\
set LOG=STOPXPS.LOG
set XPSDIR=d:\xps
set testsvc=testsvc1.fil
set UTILS=d:\progra~1\utils




echo ====================== >>%LOGGING%%LOG%
echo Stopping Xpress Server >>%LOGGING%%LOG%
echo ====================== >>%LOGGING%%LOG%
ECHO . >>%LOGGING%%LOG%

DATE /T >>%LOGGING%%LOG%
TIME /T >>%LOGGING%%LOG%
ECHO . >>%LOGGING%%LOG%



psservice stop "Xpress Server"

rem "wait long enough for server to stop before checking the status
beask "Waiting for server to stop" Default=y Timeout=45

psservice query "Xpress Server" >%XPSDIR%\%testsvc%

type %XPSDIR%\%testsvc% |find "STOPPED" >>%LOGGING%%LOG%


type %XPSDIR%\%testsvc% >>%LOGGING%%LOG%


echo "Xpress Server Service stopped ********" >>%LOGGING%%LOG%







 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
The server has rejected your login. Please verify that your userna frustr8edw/microsoft Windows Vista Mail 99 01-24-2011 01:59 PM
Wsus Reporters and ApiRemoting30 Roger Abell [MVP] Update Services 16 12-28-2010 02:36 PM
Application Log Report Id: 96a6ab4b-710d-11df-a896-0023aee6baaf _prefix Internet Explorer 5 06-07-2010 08:43 PM
Windows Update Error Code: 80070005 Joe Davis Windows Update 33 05-05-2010 08:03 AM
2nd Domain in a 2 domain forest cannot be contacted David Alge DNS Server 30 01-21-2010 05:26 AM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59