What syntax should I use to call a job in Stored Proc?

Question

Post reply

What syntax should I use to call a job in Stored Proc?

rachellebs

Ten Centuries

Points: 1144
More actions
June 6, 2008 at 1:11 am

#380973

Hi to all,
Hope you can help me in creating a stored proc that will call a job in sql server agent... I'm a newbie in Sql server 2005 so I don't know what syntax should I use....
Any response will be appreciated....
Thanks! 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

rajdba Ten Centuries Points: 1362 More actions · Answer 1

Try to Use

sp_start_job

Try to findout more about it in book online

Regards,

Raj

mtudo008 Old Hand Points: 314 More actions · Answer 2

Hi there,

Try this link: http://www.simple-talk.com/sql/sql-server-2005/executing-ssis-packages-/

dva2007 SSCertifiable Points: 7707 More actions · Answer 3

Hi,

I hope you already prepare stored procedure which does whatever you want. You can easily schedule this stored procedure into Job.

Just go to Jobs in Mannagement studio and schedule - New JOb.

You just need to give Name of the job in General.

In steps you need to give command like exec sp_name

In schedule you select what time you need to run this job.

thats it.

please let me know if you need any further detail.

regards,

vijay

dva2007 SSCertifiable Points: 7707 More actions · Answer 4

Hi,

Just refer to following link as well.

http://www.sqlservercentral.com/articles/Administering/sqlserverjobscheduling/2288/

regards,

vijay

rachellebs Ten Centuries Points: 1144 More actions · Answer 5

Hi all,

Actually I run my SSIS packages from a Job and now I want to create a stored proc that will run a Job so that that stored proc can be called by ASP.NET....

Is my logic make sense?