Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 99pshop

    Run Job as a different user

    Thanks for that. I will give that a shot.
  2. 99pshop

    Run Job as a different user

    I have anSMTP installed on the server and have been using this with my job processes. My delema started with this new webapp function. Will xp_smtp_sendmail run under a restricted account or will it need access to core procedures or sensitive components?
  3. 99pshop

    Run Job as a different user

    BTW, I dont have exchange server running on the server.
  4. 99pshop

    Run Job as a different user

    I am using it to fire off email using an smtp component. As soon as a user registers, the insert triggers off a process to send an email. I have a job that runs every 10min as well, but as I will only get possibly 2 registration a day, it't inefficient to change the job to every minute.
  5. 99pshop

    Run Job as a different user

    I am using MS SQL 2000 sp4
  6. 99pshop

    Run Job as a different user

    I have a trigger that fires on insert. The trigger then fires off a Job using sp_start_job. which executes a stored procedure. The stored procedure my trigger calls uses sp_OACreate The account I use from my webapp doesn't have permission to sp_OACreate and I prefer not to. The job owner is...

Part and Inventory Search

Back
Top