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 |
|
Bobba Buoy
Starting Member
36 Posts |
 Posted - 2003-08-03 : 07:24:20
|
| None of my scheduled jobs are working. I am trying to back-up databases individually by scheduling them for once a day and I have a maintenance plan that is not running. I go into 'Jobs' under 'SQL Server Agent' in the 'Maintenance' folder and everything is good except the 'Status' is 'Not Running' and the 'Last Run Status' is 'Failed.' Any ideas? |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-08-03 : 18:23:06
|
| Check job history, by right click on job name. Also select "Show steps details", ti get the cause for a job failing.Sérgio MonteiroTrust in no Oracle |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-04 : 12:35:11
|
| If Show step details does not show enough information, then check the SQL Server Error Log. Often times, the Error Log will have a more descriptive error and will better help you troubleshoot the problem.Tara |
|
|
|
sj1187534
Starting Member
5 Posts |
Posted - 2004-04-25 : 02:24:22
|
| Hi...How can we see the SQL Server error log on a remote server. In my case, it is saying that the scheduled job failed but the job history is not giving me enough info.ThanksSJ |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-25 : 14:40:43
|
| To see the error log on a remote server, you need to either have access to the c$ share to look at logs in program files/ms sql server or you need to have a linked server set up. Do you have either of these?If you have access to the share, you can look at C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG.If you don't have access to this, but you have a linked server, you can run:EXEC SERVER.master.dbo.xp_readerrorlogAlso, who do you have as the owner of the jobs? Does this owner have sufficient access to do what you are trying to do the job? Normally backup jobs will need to run under the Domain Admin account that SQL Server is running under. This is especially true if they need to copy files somewhere. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Scheduled Jobs Issued