This is a failing job, not a stored procedure. The error message in the Event Viewer is:

Event Type:Warning

Event Source:SQLSERVERAGENT

Event Category:Job Engine

Event ID:208

Date:30/01/2006

Time:16:20:39

User:N/A

Computer:ANTEC

Description:

SQL Server Scheduled Job 'test2' (0x33EE095F4BC451479C4903CDEE9B0D74) - Status: Failed - Invoked on: 2006-01-30 16:20:39 - Message: The job failed. Unable to determine if the owner (ANTEC\Stefan) of job test2 has server access (reason: The server could not load DCOM. [SQLSTATE 42000] (Error 7404)).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.