quote:

---

Originally posted by mary_itohan

Hello,

1. where do i determine a job should run once ?
A job only runs once - it runs when it is called. If a job is scheduled then the job is "called" by sql agent as the schedule defines.

2. where do i determine a job should run whenever its called ?
If the job is "enabled" it will run whenever it is called.
You can maintain jobs through Management Studio | Object Explorer | <YourServer> | sql agent | Jobs

You can optionally specifiy a schedule in the job properties | schedule tab

3. based on 2 above
see 2

- How do i call this job from a Stored Proc and specify it runs whenever called ?
you can interactively right-click | start
or you can use t-sql (sp_start_job)

I believe i use sp_start_job to start the job ? What parameters
Look at books online at parameters for this proc:
http://msdn.microsoft.com/en-us/library/ms186757(SQL.90).aspx

thanks



_____________________


Yes O !

---

quote:

---

Originally posted by mary_itohan

Hello,

1. where do i determine a job should run once ?

You can use schedule to run only once

2. where do i determine a job should run whenever its called ?

Using schedule on need basis.

3. based on 2 above

- How do i call this job from a Stored Proc and specify it runs whenever called ?

I believe i use sp_start_job to start the job ? What parameters

thanks



_____________________


Yes O !

---