Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    101

    Unanswered: Sql Jobs information query.

    does any one has a query which gives, how often the job runs in a day?
    Thanks for your help.

  2. #2
    Join Date
    May 2002
    Posts
    299
    sysjobhistory table in msdb contains the info you need.

    e.g.
    select job_id,count(*) cnt
    from msdb..sysjobhistory
    where job_id=1234
    and run_date='20050101'
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

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