Tables/DB Names ----JOBS in SQL Server???

microsoft.public.sqlserver.programming

10 Nov 2005 7:10 PM

Steve

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

10 Nov 2005 7:13 PM

Mark Stricker

In the msdb database, in the sysjobhistory table.
Show quote

"Steve" <St***@discussions.microsoft.com> wrote in message
news:FEE09742-249B-4086-97A2-3523F9DE045C@microsoft.com...
> 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