Post reply

SQL Jobs

  • February 17, 2005 at 8:03 pm

    #162655

    Hi guys,

    I  want to retrieve information of the existing SQL Jobs using a T-SQL query. Can any of the system tables or SPs be used for this purpose?

    Thanks,

    Hari

     

     

     

    Kindest Regards,

    Hari

  • February 17, 2005 at 8:10 pm

    #542998

    Have a look in the MSDB Database. Tables such as sysjobs, sysjobhistory etc.

    Kindest Regards,

  • February 17, 2005 at 8:26 pm

    #542999

    Thanks, Just had a look

    -Hari

    Kindest Regards,

    Hari

  • February 18, 2005 at 4:04 am

    #543041

    use msdb

    go

    select * from sysjobs

    select * from sysjobsteps

    select * from sysjobserver

    select * from sysjobhistory

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply