Does a product exist for SQL Server 7.0 that would allow me to define complex job flows using dependencies and prerequisites?
I’m using FTP logging to trigger jobs to run. I currently write jobname to a table as the last step of all of my SQL Server jobs. An INSERT trigger on that table uses the jobname to determine which job(s) to run next. There are situations where I may trigger up to 15 jobs in parallel. When the parallel all complete, the trigger continues to run additional jobs. This process works, but I would like to find a more robust and flexible application to define my job schedules. I would also like to be able to distinguish between iterations of these batch runs.
Has anyone heard of this type of product being available, or should I continue to develop a solution on my own?