I've got a php page that, under certain, rare circumstances, adds a row to a table.
The goal is to receive an email notification whenever a row is inserted.
xp_sendmail is not an option (have 'sa' access to mssql, but little access on the box itself). MSSQL Notifications are out for the same reason.
I have an ActiveX script that can handle this and have been trying to figure out a way to get a trigger to call it. I tried setting up a job and using sp_start_job.
Logged in under sa, it works great. Under other non-admin users:
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 38
The specified @job_id ('[job identifier]') does not exist.
I then tried to create a procedure that calls sp_start_job, and granted execute to the web user. Same result.
Any ideas how I can have an insert trigger an ActiveX script without significantly upgrading the web login's permissions? (The page is on a windows server where the php mail command does not work, so that's not an option).
Thanks for the help in advance. It's been a while. Glad to be back.
The goal is to receive an email notification whenever a row is inserted.
xp_sendmail is not an option (have 'sa' access to mssql, but little access on the box itself). MSSQL Notifications are out for the same reason.
I have an ActiveX script that can handle this and have been trying to figure out a way to get a trigger to call it. I tried setting up a job and using sp_start_job.
Logged in under sa, it works great. Under other non-admin users:
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 38
The specified @job_id ('[job identifier]') does not exist.
I then tried to create a procedure that calls sp_start_job, and granted execute to the web user. Same result.
Any ideas how I can have an insert trigger an ActiveX script without significantly upgrading the web login's permissions? (The page is on a windows server where the php mail command does not work, so that's not an option).
Thanks for the help in advance. It's been a while. Glad to be back.