How could I retrieve info about all the jobs using SQL query?

How could I retrieve info about all the jobs using SQL query?
-DSee msdb.dbo.sp_help_job in BOL.
AMB
"D'Animal" wrote:

> How could I retrieve info about all the jobs using SQL query?
> -D|||Start with:
select * from msdb..SysJobs
From there there is also SysJobSteps, SysJobHistory, etc.
"D'Animal" <D'Animal@.discussions.microsoft.com> wrote in message
news:0AA55366-FC84-46AF-9A3B-C6FEE21D2184@.microsoft.com...
> How could I retrieve info about all the jobs using SQL query?
> -D|||I got it. Thank you.
-D
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See msdb.dbo.sp_help_job in BOL.
>
> AMB
> "D'Animal" wrote:
>