Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deal11deal1
Starting Member
34 Posts |
 Posted - 2011-01-20 : 15:05:01
|
| Hello Guys,we have a production server A and Mirror server B for DR.every thing on the server a is exactly the same as server b.mirroring is set up at server bI have this job that pulls the data from a table in a database and puts it in a table in a different database on server a.the name of the job lets say is jobAit runs every 15 min and copies the datathe job is moved to mirror server every nightthe job on server a is runing finebut the same job on server b is failing since last night.in the job view history I not giving me any details just error saying the job failed on step 1.these are the exact error i am getting when view job history and look at the job."the first node said simply " The Job was invoked by User sa. The last step to run was step 1 (step1).and the second node says " domain\sqlagentaccount. d DTSER_FAILURE (1). Started: 1:41:20 PM Finished: 1:42:03 PM Elapsed: 42.656 seconds. The package execution failed. The step failed."pls help.Thanks in advance. |
|
|
|
|
|
error sql agent job failing.