October 26, 2004 at 12:36 am
I want a few users to be able to update a table using isql command which will trigger a stored procedure which inturn will run a job. But the problem with this that these users are not sysadmins and they can only run jobs that they own.
Any work around for this?
thanks a million
October 26, 2004 at 9:37 am
Have them insert a value in a table. Setup a job owned by sa that checks the table. If the value is there, start the job and mark the row in the table, delete it, whatever. You can schedule that job for every minute.
October 28, 2004 at 10:31 am
I have seen replies posted here which gave the solution of creating an alert which would start the job. In your SQL code, you would have a RAISEERROR which would trigger the alert. That way the job would run only when needed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply