Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2007-09-12 : 02:50:37
|
| Electronic Checklist that can execute SSIS packages based on a flag/correct Tick1. Task1 : (with a tick, indicating successfull) Now that task is green tick execute Task2 2. Task2 :Some other software or so that can relate with SSIS or DTS then return to a value or so then indicate on the software checklist that is done the continue to next task. The reason being is that we can open the electronic checklist & to also view the checklist & indicate everything was successfull if not indicate the red ticks(unsuccessfull). We execute a list of tasks (being DTS packages, SSIS, copying of ascii files to network) etc. one after another The problem is that it's unstable were the task will execute based on a previous task that might have encounted errors so we only really notice once a user complains or on arrival in the mornings then it's to late. The idea that we want to incorporate a electronic checklist were it execute a job goes back to the checklist(?) sets it's flag or ? and then on true/flag execute the next task. I apologise as this is part of another post but I totally messed up the previous post with the wrong question. Regards |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 22:44:18
|
| Possible to put them in single job as separate job steps? If so, you can make workflow in the job. |
 |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2007-09-13 : 02:30:47
|
| Thanks, can you please elaborate more in detail as I lost you. We are thinking of something like the SQL Agent Job but not the Job menu, the Start Job at Step Menu. You can execute it again & one can set the flow & see the status. Regards, |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-13 : 22:50:02
|
| Each sql job can have multiple steps, and you can specify which step to go next based on previous step's status. Check books online for details. |
|
|
|
|
|
|
Electronic Checklist that can execute SSIS package