April 28, 2009 at 12:54 pm
i have this sql job scheduled to run at 3:am - it runs most of the time ok - it fails 3 to 4 times a month. the error i get is this one:
Description:
SQL Server Scheduled Job 'TIMEEXPORT' (0CE6AD711A5C300508B) - Status: Failed -
Invoked on: 2009-04-27 03:00:02 - Message: The job failed. The Job was invoked by Schedule 15 (TIMEEXPORT).
The last step to run was step 2 (Check for short run time).
does this error, in general terms, means something? maybe i am missing something obvious in this error -
thanks
April 28, 2009 at 12:58 pm
If you check the logs, it'll generally have a lot more data about the error. Or you can right-click the job in Management Studio, select History, and then click the plus next to the time it failed, select the step that failed, and scroll down in the window a bit. It'll often have more details there too (those details come from the log, but some people find using the GUI to get at it is easier).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 28, 2009 at 1:55 pm
i checked the logs - i dont see anything related to this job when it fails (it is sql2000). i have studio express mgmt on a computer, i am able to connect to this database but i dont see the jobs under 'management' i just see activity monitor, full text search and sql server logs - i cant even open these logs from studio -
are the jobs located someplace else? sorry - i am new at managing sql stuff -
thanks in advance
April 28, 2009 at 2:48 pm
Sorry, I'm so used to Management Studio that I sometimes forget to check which forum I'm in.
In Enterprise Manager, you'd go to Management, Jobs, right-click the failed job, "View Job History...", check "Show step details", and select the failed step. That'll get you to the same point.
In Management Studio, jobs aren't under Management any more. They're under SQL Server Agent, which is the last one on the list for the server/instance. That may not show in Express, I'm not sure.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 28, 2009 at 4:00 pm
thank you - it was helpful -
yeah - studio doesnt show the agent part -
April 29, 2009 at 7:33 am
Glad I could help.
If you want a full copy of Management Studio, get a copy of Dev Edition of either SQL 2005 or 2008. It's about $50 (US). With that, you can install Management Studio on whatever computer you want.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply