Web Development

Ask something
Discussion Locked

SQL Server Job Scheduling

0 helpful
3 replies

by geoff.walter

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by lexingtonit

I guess you could write a Stored Procedure to implement your job control, then schedule that SP to run at certain time. SP could access both SQL tables and extended programs.
Or you could write a program using any languages that could easily accessSQL tables and control other programs, like VB or Windows Host Script.

Willie

by geoff.walter

Good thought, I've already custom coded a solution. What I was hoping for was a hardened, configurable, integrated add on to SQL Server that was more flexible and functional than the native job scheduler.

This discussion is closed to new replies.