August 6, 2008 at 7:06 am
The job failed. The Job was invoked by User AMADEUSSBS\administrator. The last step to run was step 1
August 6, 2008 at 8:07 am
Very interesting!
Can you provide just a little bit more information? What does the job? Which step failed?
I don't think you'll get any answer with such a post!!
-- Gianluca Sartori
August 6, 2008 at 5:04 pm
Well, to begin with I would see if AMADEUSSBS\administrator has the privileges to run the jobs. And if it does the next step would be to look for all the steps that are involved in this job. Usually when something is scheduled as a job, then go check for the parameters mentioned in the job against the DB, that shall help resolve the issue..:)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
August 7, 2008 at 4:51 pm
I am not sure what this error is, I get it myself with logshipping and cant work it out. The log-shipping works for a while and the user does have the right privliges and then it fails. I just reinstall as no one can tell me why this happens.
maybe you should do the same. sorry I cant help futher, if I get any more info on this problem you will be the first to know.
Regards,
Terry
August 8, 2008 at 7:02 am
open the job with properties, click steps, edit (so you can see the script that the step consists of),
then copy the full script. Now go to tools and open a new query window. Paste the step script
in the window and run it... it will tell you in a message what happened and why it failed. Good luck!
John
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply