> Helps if I add the tables for you too! :)
>
> look at msdb..sysjobhistory and msdb..sysjobs
>
> Immy
>
> "segis bata" hotmail.com> wrote in message
> news:eF%%23AVrjaHHA.2448@TK2MSFTNGP02.phx.gbl...

>> Hello everyone,
>>
>> Is it possible (and if so, how?) to export the list job tasks (with
>> status, last run, etc.) from SQL Server to a table (in the same SQL
>> Server) so I can create a simple ASP file showing the results?
>>
>> Also, that export process should be running periodically because I don't
>> want just a snapshot of sometime in the past but a recurrent display of
>> the tasks in SQL with their particular information.
>>
>> FYI, I'm running SQL Server 2000 in a Win2003 SP1 box
>>
>> Thanks in advance for all your help...
>> SB-R
>>

>
>