September 11, 2009 at 8:51 am
one of th ejob failed due to unable to connect sql server , can u calrify any one of how to resolve the issue ?
September 11, 2009 at 8:57 am
ramyours2003 (9/11/2009)
one of th ejob failed due to unable to connect sql server , can u calrify any one of how to resolve the issue ?
Can you give me details, as in what sort of job and what was the error .
The more details you provide, the more help that people can give you...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 11, 2009 at 9:03 am
The job failed. The Job was invoked by Schedule 20 (SharedServices1_DB_JobSchedule_DeleteExpiredSessions). The last step to run was step 1 (SharedServices1_DB_JobStep_DeleteExpiredSessions).
this the ouput of the failed job
September 11, 2009 at 9:20 am
i found to install the Sp from microsoft site to resolve the issue apart of thsi is any reason for the failure of this job ?
September 11, 2009 at 9:45 am
To be honest, I don't know how to your questions as there is very little real information in any of your posts. All I know is some scheduled job failed. It would help us if you would provide more detailed information regarding the problem.
September 11, 2009 at 10:40 am
Hi Ramyours2003,
Could you provide us some more information on the job like what does the job do, whether the job is accessing any remote files or not etc..
Thank You,
Best Regards,
SQLBuddy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply