Post reply

SQL Job

  • November 14, 2013 at 8:30 am

    #300261

    I want to find out how many SQL jobs are associated with one particular DB?

    Nita

  • November 14, 2013 at 8:51 am

    #1666414

    This query will get you a list of job steps that are setup to run against a certain database:use msdb;

    go

    select *

    from sysjobsteps

    where subsystem = 'TSQL'

    and database_name = ?

    But you may have other jobs that start off with master and then have a use statement inside the command (which you can use a wildcard search to find those) or you may have SSIS jobs that access your database in which case you won't be able to query to find that information.


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • November 14, 2013 at 8:53 am

    #1666416

    Thanks:-)

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

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