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 |
|
diggers
Starting Member
8 Posts |
 Posted - 2005-07-07 : 07:09:41
|
| hello,I have created created some Maintanence with the following script.isql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -isp_estimatestats.sql -osp_estimatestats.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -isp_indexdefrag.sql -osp_indexdefrag.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -isp_recompilesptr.sql -osp_recompilesptr.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -isp_add_n_hourlyjob.sql -osp_add_n_hourlyjob.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -isp_adddailyjob.sql -osp_adddailyjob.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -isp_addweeklyjob.sql -osp_addweeklyjob.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -isp_updatestatsjob.sql -osp_updatestatsjob.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -Q"EXEC sp_add_n_hourlyjob 'PICIS_DB', 'PICISLOG_BCK', 'C:\', 020000, 8, 235959" -oAddedHourlyJob.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -Q"EXEC sp_adddailyjob 'PICIS_DB', 'PICISDUMP', 'PICISLOG_BCK', 100, 'C:\', 200000" -oAddedDailyJob.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -Q"EXEC sp_addweeklyjob 'PICIS_DB', 'PICISDUMP', 'PICISLOG_BCK', 200, 'C:\', 20000" -oAddedWeeklyJob.outpauseisql -Usa -Psa -SGTS-COLM\PICIS -dmaster -m-1 -Q"EXEC sp_updatestatsjob 'PICIS_DB', 'C:\', 20000" -oupdatestatsJob.outpauseDoes anyone know how I can create a script to delete these jobs at a later date?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-07-07 : 07:13:51
|
| sp_delete_job can delete a job. However, if you have a specific task that you need to run every day or week, just create the job once and add the appropriate schedule to it, don't drop and recreate the job each time you want to run it. |
 |
|
|
|
|
|
|
|
Maintanence