drawing a blank...deleting jobs

 3 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
andrew
Veteran Member
Posts: 100
Veteran Member

    what would be he syntax to simply delete jobs and history for 1 specific user ?

    They have some huge jobs and will nit delete, I just need to clean them up for that user.

    Windows, and sql 2005

    thanks

    JimY
    Veteran Member
    Posts: 510
    Veteran Member
      Check out deljobhst.
      fred.kobos
      Advanced Member
      Posts: 27
      Advanced Member
        you can just manually do it thru explorer. I do not beleive their is for just one user. I use the above.
        Jimmy Chiu
        Veteran Member
        Posts: 641
        Veteran Member
          deljobhst
          Usage: To delete report files, completed job entries and
          waiting job entries with Invalid Parameter statuses.
          Syntax: deljobhst -ckrUvw [-uUserName] [-fFromDate] ToDate
          c - Delete completed job entries.
          j - Delete recurring job entries.
          k - Keep entries, do not delete.
          r - Delete batch report files.
          U - Print usage and syntax.
          v - Verbose.
          w - Delete waiting job entries.

          Syntax FromDate: MMDDYY
          Syntax ToDate: MMDDYY
          or
          'curdate' [- NbrDays]