Override a specific SQL agent job

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Override a specific SQL agent job

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Operations Manager >> Override a specific SQL agent job

Page: [1]

Message

<< Older Topic Newer Topic >>

Override a specific SQL agent job - 8/22/2008 3:59:27 PM

gmaynard

Posts: 23
Score: 0
Joined: 9/9/2004
Status: offline

I need to override a rule applied to a SQL 2000 agent (specifically: "A SQL job failed to complete successfully." under Type: SQL 2000 Agent). The catch is, I want to override a specific job that the agent runs, not all jobs the agent runs. How can I specify the specific job?

For example, the developers have created a SQL job that checks for new data entered into the database. When the job runs, and no new data is available, the job exits with a status of "failed" (this is by design, and I have no control over this). I am getting bombarded with failure warnings from this job. However, I want to see alerts if the various maintenance jobs fail on that server, so I need to weed out this one job.