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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2004-08-16 : 08:32:30
|
| Hello,I want to create job to do the following:exec sp_ArchiveBut it has to be done at the last day in month, every month. In Enterprise Manager I can make a job and choose day and hour in schedule (Occurs - Monthly, ... ), but I can't determine the last day in month (only to choose 28th or 30th or 31th day).Does anyone has sugestion, how to make a job wich would execute at the last day in month (no matter the number of days current month has)I can make a job wich would work every day, where I can ask if the current day is the last day in month, but maybe there is some more elegant solution |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 08:40:30
|
| Click on Monthly.Select Last.In the next dropdown, scroll past all the days of week and select Day.Save.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
dejjan
Yak Posting Veteran
99 Posts |
Posted - 2004-08-16 : 08:59:20
|
| I need a glasses.Thank you |
|
|
|
|
|
|
Make a job