JOBS in SQL Server

#1

Hi,
Once we create job job in SQL Server & if it fails then we can view the job
history for the failure message. In what Database & table does this message
get stored. Is it stored in MSDB or Master database? & in which table.

Please help me with above.

Thanks a lot

Steve
--
IT Developer

#2

Have a look at there

http://msdn.microsoft.com/library/de...sys-j_42yh.asp

Allan

"Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,
Once we create job job in SQL Server & if it fails then we can view the
job
history for the failure message. In what Database & table does this
message
get stored. Is it stored in MSDB or Master database? & in which table.

Please help me with above.

Thanks a lot

Steve
--
IT Developer

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

JOBS in SQL Server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

JOBS in SQL Server - 11-10-2005 , 11:16 AM

Re: JOBS in SQL Server - 11-10-2005 , 02:21 PM