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 |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-05-24 : 03:37:10
|
| HI In my organization, i need to refresh the procedures in regular intervals. i scheduled a job to run at 2.30 a.m . when i open the job history on the next day, no job history was found.could any one explain the steps in scheduling the jobs in EMThanks in advance. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-24 : 04:13:06
|
Did you set it to run DAILY ? When you create a job EM defaulted it to Weekly
KH |
 |
|
|
sreehari
Starting Member
37 Posts |
Posted - 2006-05-24 : 04:16:34
|
quote:
Originally posted by khtan
Did you set it to run DAILY ? When you create a job EM defaulted it to Weekly
KH
No for a trial , i set it to run only once that is at 2-30 am on that day. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-24 : 04:17:54
|
| CHeck to see that the job is enabled and the scedule is enabled.If you run it once to test then the schedule is disabled when it completes and you need to enable the schedule if you change the date for another run.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-24 : 04:20:17
|
"No for a trial , i set it to run only once that is at 2-30 am on that day."On the day you set the job or the following day ? 
KH |
|
|
|
|
|
|
How to create and start the Job in EM