Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 5,078, Visits: 11,857
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.
Post #1527906
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse