Re: Job succeeds manually but fails if scheduled
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 22 Mar 2006 13:51:38 +0000 (UTC)
(teddysnips@xxxxxxxxxxx) writes:
I checked on this today. All the jobs that run correctly have exactly
the same owners/permissions as the job that fails. I can't find any
attribute of the job (apart from what it actually does, obviously) that
distinguishes it from any of the other, successful jobs.
One other thing of which I was not aware. Apparently this job had been
scheduled successfully up until about a week ago, when it began
failing.
Any further thoughts/ideas?
Check View History for the job. Don't miss to check View Step History.
Unfortunately, jobs that set up from a maintenance plan does not seem to
write very much useful information, so I'm not really expecting this to
give you anything. (But check nevertheless.) I the maintenance plan has
its own log somewhere, but I don't remember where - or if there was anything
that useful in it.
May you should scrap the plan, and set up the jobs without it.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Job succeeds manually but fails if scheduled
- From: teddysnips
- Re: Job succeeds manually but fails if scheduled
- From: Bryan
- Re: Job succeeds manually but fails if scheduled
- From: teddysnips
- Job succeeds manually but fails if scheduled
- Prev by Date: Re: SQL Server License Control and Management
- Next by Date: Monitoring SQL Server transactions
- Previous by thread: Re: Job succeeds manually but fails if scheduled
- Next by thread: Re: Job succeeds manually but fails if scheduled
- Index(es):
Relevant Pages
|
