By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,703 Members | 1,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,703 IT Pros & Developers. It's quick & easy.

DOS Scripts and/or Task Center Help

P: 9
DB2 9.1 fixpak 2 on Windows

I am trying to set up a task in the task center that will run on a daily basis to check for an "issue". To find this "issue", I run a select statement that brings back a count. If the count is something other than zero, then the "issue" exists.

Is there a way to run a select statement in the task center, and from the results, mark it as either successful (count of zero was returned) or failure (something other than zero returned)?

If not, does anyone have a DOS script that can run a select statement and return values based on the results of the select statement?

I feel like this should be simple, but I just can't put a finger on it.

Thanks in advance for any help,
Dan
May 17 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.