Post reply

Query for find bdetails for Job Name - Enabled - Schedule of job

  • February 9, 2013 at 7:38 am

    #273955

    I want to write a query to find below details of jobs

    Job Name - Enabled - Schedule of job

    if job is having more than one schedule it should come in different rows

  • February 9, 2013 at 2:12 pm

    #1586252

    Look in msdb for tables dbo.sysjobs, dbo.sysjobschedules and dbo.sysschedules. Those three have what you need.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 10, 2013 at 3:20 am

    #1586286

    Thank you...:-)

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

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