drawing a blank...deleting jobs

 3 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
andrew
New Member Send Private Message
Posts: 0
New 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 Send Private Message
Posts: 510
Veteran Member
Check out deljobhst.
fred.kobos
Advanced Member Send Private Message
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 Send Private Message
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]