Hi all,
I need to create some Scheduled Tasks on a remote server that will run some SQL Stored Procedures on the Site Database Server in order to dump some data out to *.CSV files. A Service Account to run these Scheduled Tasks has been created but I'm not overly sure what permissions are required on the SQL side to get this to work. Ideally I'd like to keep the permissions to a minimum (i.e. they can run the stored procedures against the relevant tables and that's it), rather than just granting blank admin access. Hoping someone has done this before and can advise me please to save me trying to reverse engineer this. Many thanks in advance. Kind regards, Cliff
