Can db2 scripts be automated?
I have a scenario where it is necessary to execute some scripts daily.Is it possible to automate the execution via some tools.?
Mystic last edited by user
Yes, it's possible and in two different ways.
Using the Administrative Task Scheduled (ATS) built inside db2 to execute scheduled operations.
the db2 command can also read command from a file specified from the command line
The two solution have both pros and cons: the setup of the AST solution requires administrative privileges on the db while the command line doesn't need changes on the database, on the other side the command line version requires to be scheduled using an external cron daemon while the AST use the scheduling service offered by db2