October 23, 2005 at 7:32 pm
Hi There
i've using a websense product to monitor, control, and report on corporate internet traffic
part of that is MSDE based data base for reporting, one of the services called Log Server that log web browsing was running fine for 3 weeks then all of a sudden stopped, i'm starting it and started fine then after 10 seconds stopped again
in the event log it it showing this error
"SQL Server Scheduled "Websense_Summary_Job_wslogdb55" (0xD9EB33......) Saturs: Failed - Invoked on date - Message: The job failed. The job was invoked by Schedule 1 (Schedule) the last step to run was step 1
The details of this event is Source: SQLSERVERAGENT
Category: Job Engin
Event ID: 208
any idea on where is the problem and i'm not a real SQL expert
appreciate any help or feed back
Emad
October 24, 2005 at 8:04 am
Emad,
Let try to get a better error message to see what is happenning.
Log on the the server and open a command window and run this...
osql -S. -E -Q"select sj.name , sh.step_name , sh.message from msdb..sysjobhistory sh , msdb..sysjobs sj WHERE sj.job_id = sh.job_id AND sh.run_status = 0" -oC:\saerrors.txt
This command queries the job history table which should have more information.
Look at the file C:\saerrors.txt with notepad and show us what it says about that job. Unless it gives you the info you need to realize what the problem is.
Norman
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply