locked
Query Script required for SQL Agent Jobs RRS feed

  • Question

  • Hi,
    we use a bit of software called LiteSpeed to backup all of our SQL databases which will create Jobs in SQL Server Agent > Jobs.

    Does any body know of the tables that are used to store inforation about jobs as I would like to create a query that can list all of the databases that are not being backed up. I know how to list the databases on the server, just not the list of jobs.

    Cheers,

    ded_innit


    In Vegas, you get a million mexicans standing in a line flipping "lady" cards at you.
    Thursday, September 24, 2009 1:00 PM

Answers

  • Check in "msdb".
    Tables "sysjobs", "sysjobsteps", etc
    • Marked as answer by Ded_innit Thursday, September 24, 2009 1:09 PM
    Thursday, September 24, 2009 1:05 PM

All replies

  • Check in "msdb".
    Tables "sysjobs", "sysjobsteps", etc
    • Marked as answer by Ded_innit Thursday, September 24, 2009 1:09 PM
    Thursday, September 24, 2009 1:05 PM
  • Tidy. I was looking in master.

    Ta very much - a nice and easy one
    In Vegas, you get a million mexicans standing in a line flipping "lady" cards at you.
    Thursday, September 24, 2009 1:09 PM