I have a long running process that i would like to have started via a web
application. I suppose I have a few options and im not sure if #1 is
possible.
#1 - Start A Job via ASP or ASP.NET
#2 - Set a Flag that a job checks when it runs on a repeating schedule so
it will take action instead of just repeating again next time the schedule
hits.
#3 - Make sure all is ready for the job which occurs at a known time (a bad
idea)
Anyone know if #1 has a solution?You can start a sql job by calling this stored procedure.
e.g.
exec msdb..sp_start_job 'your_job'
-oj
"Erik Jensen" <ErikJensen@.discussions.microsoft.com> wrote in message
news:D1D61D84-36C5-40C9-8990-B4D8D11D2677@.microsoft.com...
>I have a long running process that i would like to have started via a web
> application. I suppose I have a few options and im not sure if #1 is
> possible.
> #1 - Start A Job via ASP or ASP.NET
> #2 - Set a Flag that a job checks when it runs on a repeating schedule so
> it will take action instead of just repeating again next time the schedule
> hits.
> #3 - Make sure all is ready for the job which occurs at a known time (a
> bad
> idea)
> Anyone know if #1 has a solution?
>
No comments:
Post a Comment