Link to home
Start Free TrialLog in
Avatar of Robb Hill
Robb HillFlag for United States of America

asked on

SQL Server - executing an agent job from a stored proc

Please help:

I have a stored proc...that get fired to run based on certain conditions.

I have created an job on sql agent that runs under my service account.  Its running under a proxy.

Here is my issue.

I want to execute this job not from a scheduler but from a stored proc.  I simply was thinking I could call it easily...but I do not seem to be able to find it ..or create the correct syntax.

The job is simply setup as a job to run on sql agent..  It is on no schedule.

I want it to only run if called from my stored proc.


Please help..
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Robb Hill

ASKER

Thank you very much Pawan!