Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nishi57
Starting Member
20 Posts |
 Posted - 2007-12-20 : 09:56:43
|
| I was hoping if someone can help me shed some light on the following error messages - Some of the billing jobs in SQL are failing, here is the message from application log - This is happening on the production server."SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan3'' (0x8BCD2C33DF5EC447BC7F1228E2C455E4) - Status: Failed - Invoked on: 2007-12-20 06:00:01 - Message: The job failed. The Job was invoked by Schedule 54 (Schedule 1). The last step to run was step 1 (Step 1)."Has anyone seen this message before, whats a way to fix this issue. Nishi |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-12-20 : 10:20:49
|
| Go to the job scheduler, and check the history of the job. It should give you a more detailed reason as to why the job failed.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 15:22:53
|
| Check sql server log, it'll tell you why backup failed. |
|
|
|
|
|
|
Some jobs failing in SQL