Job scheduler

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.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.|||Thanks Hari
Anand.

>--Original Message--
>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...
the
>
>.
>

Job entries in eventlist

Hi all
in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
All these jobs are logged in the eventlist, although the control field in th
e
job proprties are deactivated. The list contains tons of event entries every
day of all backups and so much the worse die log backups.
It's this a fault in the enterprise manager or SQL-server? And, have any one
a reason for this problem?
Thanks
FieteIf I understand you question correctly:
It isn't Agent that log each time a backup is performed. It is SLQ Server.
And you cannot turn it
off, I'm afraid. Considering posting such a request to sqlwish@.microsoft.com
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Fiete" <Fiete@.discussions.microsoft.com> wrote in message
news:AC1F6A5E-64E4-48CB-AD8E-BA39535BFD37@.microsoft.com...
> Hi all
> in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
> All these jobs are logged in the eventlist, although the control field in
the
> job proprties are deactivated. The list contains tons of event entries eve
ry
> day of all backups and so much the worse die log backups.
> It's this a fault in the enterprise manager or SQL-server? And, have any o
ne
> a reason for this problem?
> Thanks
> Fiete

Job entries in eventlist

Hi all
in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
All these jobs are logged in the eventlist, although the control field in the
job proprties are deactivated. The list contains tons of event entries every
day of all backups and so much the worse die log backups.
It's this a fault in the enterprise manager or SQL-server? And, have any one
a reason for this problem?
Thanks
Fiete
If I understand you question correctly:
It isn't Agent that log each time a backup is performed. It is SLQ Server. And you cannot turn it
off, I'm afraid. Considering posting such a request to sqlwish@.microsoft.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Fiete" <Fiete@.discussions.microsoft.com> wrote in message
news:AC1F6A5E-64E4-48CB-AD8E-BA39535BFD37@.microsoft.com...
> Hi all
> in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
> All these jobs are logged in the eventlist, although the control field in the
> job proprties are deactivated. The list contains tons of event entries every
> day of all backups and so much the worse die log backups.
> It's this a fault in the enterprise manager or SQL-server? And, have any one
> a reason for this problem?
> Thanks
> Fiete