Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

SSIS switchboard/menu/dashboard ... ? Expand / Collapse
Posted Thursday, January 2, 2014 12:05 PM


Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
Post #1527250
Posted Sunday, January 5, 2014 8:32 AM



Group: General Forum Members
Last Login: Today @ 5:25 PM
Points: 7,977, Visits: 19,108
There are some issues that you will face with this solution.

Let's assume that you have the packages developed & deployed. You have 12 SQL Agent jobs created. You have built a client app that connects to the relevant SQL instance and runs sp_start_job when a certain button is clicked on the form.

Your first issue is user feedback. sp_start_job runs asynchronously and therefore you cannot easily monitor the progress of the job from the client app.

When the job completes, how will the user know?

If the job goes wrong, how will the user know?

What happens if several users click the same button?

Do you want to give your users rights to start SQL Agent jobs?

How do you prevent the same file being processed more than once?

(OK, the last one is easy: archive it after processing.)

Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

If your posting includes some T-SQL code, please surround the code with IFCode formatting tags. It helps readability a lot.
Post #1527906
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse