SEO

#1 (**permalink**) 02-29-2008, 07:27 AM

Can anyone help me troubleshoot this failed job. The error message in event
viewer is:

SQL Server Scheduled Job 'Job1' (0xB1D83B7357CF2B4C808AD1CFA34CE8F9) -
Status: Failed - Invoked on: 2005-05-12 09:31:38 - Message: The job failed.
The Job was invoked by User sa. The last step to run was step 1 (Job1).

The job step is:

EXEC proc1

I can execute the procedure in QA.

Proc1 does the following:

INSERT values into a table in the database where the job is running from
SELECT records from a seperate database on seperate server

I'm using four part naming in the select against a linked server. I suspect
that the issue is the security between the different servers/databases but I
don't know where to get more information about the failed job or what to try
next.

thanks

#2 (**permalink**) 02-29-2008, 07:28 AM

To get more information, right-click the job in Enterprise Manager, and
choose View Job History, then check Show Step Details - that will give
you more information on what exactly happened when the step ran.

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Troubleshooting failed job