Prev
Next
Forums S3 Systems Administration

drawing a blank...deleting jobs

Sort:
You are not authorized to post a reply.
Author
Messages
andrew
Veteran Member
Posts: 100
Veteran Member
3/12/2010 5:00 PM

    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
    3/12/2010 5:11 PM
      Check out deljobhst.
      fred.kobos
      Advanced Member
      Posts: 27
      Advanced Member
      3/12/2010 5:57 PM
        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
        3/12/2010 7:15 PM
          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]

          You are not authorized to post a reply.