Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2006-06-02 : 20:31:51
|
| Hi,I need to setup something like 'never ending job' that can fired every two mintues which will call the SSIS file to do the download and update some tables.The Server agent only let me set daily,weekly job, but not every two mintues. Any idea are welcome.Thanks a lot |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-06-02 : 21:02:06
|
| If you go to a job's properties, click on the schedule tab, click edit button, select Recurring schedule type and click the Change button, you should see in the "Daily frequency" area an option for "Occurs every:". From there, you can select any frequency of minutes or hours. |
 |
|
|
|
|
|
never ending job?