Re: Job scheduler

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 09:19:30 +0530

Hi,

Data will be stored in SYSJOBHISTORY table of MSDB database

Column name is : RUN_STATUS
The column hols the below status,

0 = Failed
1 = Succeeded
2 = Retry
3 = Canceled
4 = In progress

Since querying the system table is not advisible , you can execute the
system procedure "SP_HELP_JOBHISTORY" to get the information regarding the
status of each scheduled task.

Thanks
Hari
MCDBA

"Guru S. Anand" <anonymous@discussions.microsoft.com> wrote in message
news:2d1b01c3fcd6$10b00d80$a001280a@phx.gbl...
> Hi all
> In which table in msdb Database the Executing status of
> the job is stored. I need the table name - which holds the
> information like
>
> 1. Job started.
> 2. Job executing
> 3. Job completed info.
>
> The above status may be in the same field of the table
>
> Thanks in advance
> Anand.