February 16, 2010 at 4:06 pm
Hi,
I have a job named 'REINDEX_dbname' for reindexing. It was working fine before, but this time job was failed.
This is the error/message that I got:
The job failed. The Job was invoked by Schedule 9 (Schd). The last step to run was step 1 (HRPRD).
Can someone help me?
Thanks,
February 16, 2010 at 4:19 pm
What is the error information associated with Step 1?
Drill into step 1 from the job history.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 5:12 pm
Hi Jason,
I guess, I figured that out. There was a mistake in my T-SQL in step 1.
Thank you
February 16, 2010 at 5:23 pm
Thanks for the update. Is it working correctly now, then?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply