DB2 Schedule scripts to run

DB2 10.5 on Windows.

Does anyone know of a good tool to schedule SQL scripts with DB2 on windows?  Currently, I am using bat files that get run from the Windows Task Scheduler but that make me really nervous.  Would love to have like a SQL Agent (from Microsoft SQL Server) app to do this.  Thanks.!

Jim
Jim YoumansSr Database AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent OlsenData Warehouse Architect / DBACommented:
Hi Jim,

What you're doing now is fine.  I do the same thing on my DB2 and Oracle systems.  

My only concern with bat files is hiding account names and passwords from prying eyes.  That's solved by using shell variables for these items and setting them by running a script that most users can't access.

Kent
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim YoumansSr Database AdministratorAuthor Commented:
Coming from an MSSQL background I am used to a much more robust system in SQL Agent.  Multiple schedules, error logging, job retries, etc.

I find it hard to believe that DB2 does not have that kind of system already.  Using bat files and windows task scheduler feels more like the flintstones.

Jim
0
Kent OlsenData Warehouse Architect / DBACommented:
There are several 3rd party tools out there that will do most of what you want, but I've never used any of them and have no recommendations.

My career started with O/S development.  Bat files are a huge step up from writing assembly programs with all appropriate error handling!

:)
0
Jim YoumansSr Database AdministratorAuthor Commented:
I agree, but I stopped using bat files years ago.  DB2 should have this built in by now.  Thanks!
0
Kent OlsenData Warehouse Architect / DBACommented:
It's not as robust as the SSIS/SSMS tools, but DB2 does have it's own built-in task scheduler.  It operates much like the Windows Task Scheduler in that it runs tasks or jobs that you've created.  The drawback is that those tasks are user-defined procedures.  The bat files are probably more flexible and easier to maintain than procedures.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.