job is fail in sqlserver? what are the reasons to fail the job
-
job is fail in sqlserver? what are the reasons to fail the job?
please help me.
thanks
venkat.
-
it depends on the job. way to many reasons to fail.
a job can be poorly written, try to access databases or database objects that don't exist(anymore? maybe someone dropped a table or db)
a job could fail if it tries to access a source outside of SQL server that the SQL Account does nto have access to..file shares, xp_cmdshell...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
What is the job designed do? What is the error message with which the job fails?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga -
@ venkat
Post hte job code here
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP -
Has the job always failed, or has it just started failing?
If you right click on the job in ssms and click on view history what does the error message say?
Hope this helps,
Rich[p]
[/p]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply