Results 1 to 3 of 3

Thread: job listing

  1. #1
    Join Date
    Oct 2003
    Location
    Brazil
    Posts
    30

    Question Unanswered: job listing

    Hi fellas.

    I need you to answer a question:
    What should I do and which SQL Server tool do I have to use in order to find a job listing on the database ?

    Thanks in advance,
    Abrahão.

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    hi
    you can view the jobs (scheduled or current activity in the enterprise manager) or in SQL Analyzer run this:

    use msdb
    sp_help_job

    Saludos
    Abel.

  3. #3
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    or this:
    select * from msdb..sysjobs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •