I want to complete this task but don't know how. Need help!!
I want to give Users to execute SQL AGENT JOB. SQL Agent is running SSIS Package. I was thinking to give some kind of Click Button Access to user so user can execute the SSIS Package/SQL Agent Job,The folder I will create in Network drive and inside the folder could be Excel File to run Macro to call SSIS Package or other option. I would like to know how I can accomplish this task. FYI in user machine SQL SERVER/BIDS are not installed and Users doesn't have permission to sql server.