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 |
|
phippsp
Starting Member
2 Posts |
 Posted - 2004-08-24 : 22:51:24
|
| I have a number of dts packages and batch jobs that require high privileges e.g. ability to run xp_cmdshell etc. I wish to allow users to initiate these tasks on a manual basis i.e not scheduled but obviously the user must not receive the elevated privileges. I am thinking about storing the tasks in a table and allowing users to pick a task, inserting a row into a "TasksToRun" table plus have a scheduled job (using high privileges) running every minute to looks for entries in the "TasksToRun" table. I don't want to have to load much on the client side either e.g. could load osql or use a web page. Does anyone have a more elegant solution. Cheers. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-24 : 23:29:21
|
| I think that's probably the best solution if there's no way to get it out of the DTS package to a stored procedure. Just use an ASP.NET page to call a stored procedure inserting into the TasksToRun table. You might want to have a complete status on that table so you can report back to the user when it's done.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
phippsp
Starting Member
2 Posts |
Posted - 2004-09-02 : 19:26:22
|
| Thanks MeanOldDBA,Nice to know I am on the right path. |
|
|
|
|
|
|
Job Scheduling (security issues)