STSADM Richness on Office SharePoint Server 2007 and WSS v3
A neighbor of mine asked me how to change the immediate alerts in WSS v3/SharePoint Server 2007 to 1 minute. He's doing a lot of demos and doesn't want to wait for 5 whole minutes (default). Below in bold is what I sent him. Another reason you might want to tweak this property is to improve perf... if you're trying to reduce the database calls, I'd recommend increasing this value to 30 minutes. Think about it... if you're making round trips every minute to your SQL box, you potentially could end up with a lot of open connections with SQL that eventually could become blocking... Note that this immediate alerts property apply to workflows, alerts, and other immedate jobs, etc... so be careful how you "tune" your settings.
One other tidbit. If you ever copy from an email to command line you'll notice that the - turns into a different dash than the one in the command line. (I think it's a funky font thing.) If you ever have problems or see wierdness, make sure you remove the - and re-type it. This could save you hours of banking your head against the keyboard.
(Change the -url http://localhost to your web application name.)
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsadm -o setproperty -propertyname job-immediate-alerts -url http://localhost -propertyvalue "every 1 minutes between 0 and 59"
Don't you love how nested this path is? Quick tip for ya... In IT we always created a command line shortcut to the stsadm path on our servers...
By the way, you can tell just how rich the command line API is by the length of this, and this isn't all. There are a bunch of properties for each of these operations.
Usage:
stsadm.exe -o <operation> [<parameters>]
stsadm.exe -help [<operation>]
Operations:
activatefeature
addalternatedomain
addcontentdb
adddataconnectionfile
addexemptuseragent
addpath
addpermissionpolicy
addsolution
addtemplate
adduser
addwppack
addzoneurl
allowuserformwebserviceproxy
allowwebserviceproxy
associatewebapp
authentication
backup
backuphistory
binddrservice
blockedfilelist
canceldeployment
changepermissionpolicy
copyappbincontent
createadminvs
createcmsmigrationprofile
creategroup
createsite
createsiteinnewdb
createssp
createweb
databaserepair
deactivatefeature
deleteadminvs
deletealternatedomain
deletecmsmigrationprofile
deleteconfigdb
deletecontentdb
deletegroup
deletepath
deletepermissionpolicy
deletesite
deletesolution
deletessp
deletessptimerjob
deletetemplate
deleteuser
deleteweb
deletewppack
deletezoneurl
deploysolution
deploywppack
disablessc
displaysolution
editcmsmigrationprofile
editcontentdeploymentpath
editssp
email
enablecmsurlredirect
enablessc
enumalternatedomains
enumcontentdbs
enumdataconnectionfiledependants
enumdataconnectionfiles
enumdeployments
enumexemptuseragents
enumformtemplates
enumgroups
enumroles
enumservices
enumsites
enumsolutions
enumssp
enumssptimerjobs
enumsubwebs
enumtemplates
enumusers
enumwppacks
enumzoneurls
execadmsvcjobs
export
extendvs
extendvsinwebfarm
formtemplatequiescestatus
getadminport
getdataconnectionfileproperty
getformtemplateproperty
getproperty
getsitedirectoryscanschedule
getsitelock
geturlzone
import
installfeature
managepermissionpolicylevel
migrateuser
moveossindex
movepropagationlocation
osearch
preparetomove
profilechangelog
provisionservice
quiescefarm
quiescefarmstatus
quiesceformtemplate
reconvertallformtemplates
registerwsswriter
removedataconnectionfile
removedrservice
removeexemptuseragent
renameserver
renameweb
restore
restoressp
retractsolution
retractwppack
runcmsmigrationprofile
runcontentdeploymentjob
scanforfeatures
searchdiacriticsensitive
setadminport
setapppassword
setconfigdb
setcontentdeploymentjobschedule
setdataconnectionfileproperty
setdefaultssp
setformtemplateproperty
setholdschedule
setpolicyschedule
setproperty
setrecordsrepositoryschedule
setsearchandprocessschedule
setsearchserver
setsharedwebserviceauthn
setsitedirectoryscanschedule
setsitelock
setsspport
setworkflowconfig
siteowner
spsearch
sync
syncsolution
unextendvs
uninstallfeature
unquiescefarm
unquiesceformtemplate
unregisterwsswriter
updateaccountpassword
updatealerttemplates
updatefarmcredentials
upgradesolution
userrole
verifyformtemplate
Examples:
stsadm.exe -o addpath -url http://server/sites -type wildcardinclusion
stsadm.exe -o adduser
-url http://server/site
-userlogin DOMAIN\name
-useremail someone@example.com
-role reader
-username "Your Name"
-siteadmin
stsadm.exe -o backup -url http://server/site -filename backup.dat -overwrite
stsadm.exe -o backup -directory c:\backup -backupmethod full
stsadm.exe -o createadminvs
-admapcreatenew
-admapidname StsAdminVs
-admapidtype configurableid
-admapidlogin DOMAIN\user
-admapidpwd Password
stsadm.exe -o createsite -url http://server/site
-ownerlogin DOMAIN\name
-owneremail someone@example.com
stsadm.exe -o createweb -url http://server/site/web
stsadm.exe -o deletesite -url http://server/site
stsadm.exe -o deleteweb -url http://server/site/web
stsadm.exe -o enumsites -url http://server
stsadm.exe -o enumsubwebs -url http://server/site/web
stsadm.exe -o enumusers -url http://server/site/web
stsadm.exe -o extendvs -url http://server:80
-ownerlogin DOMAIN\name
-owneremail someone@example.com
stsadm.exe -o renameweb -url http://server/site/web1 -newname web2
stsadm.exe -o restore -url http://server/site -filename backup.dat
stsadm.exe -o restore -directory c:\backup -restoremethod overwrite
stsadm.exe -o setconfigdb -databaseserver server
stsadm.exe -o unextendvs -url http://server
For information about other operations and parameters,
use "stsadm.exe -help" or "stsadm.exe -help <operation>"
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsa
dm -help getproperty
stsadm.exe -o getproperty
-propertyname <property name>
[-url <url>]
SharePoint cluster properties:
avallowdownload
avcleaningenabled
avdownloadscanenabled
avnumberofthreads
avtimeout
avuploadscanenabled
database-connection-timeout
data-retrieval-services-enabled
data-retrieval-services-oledb-providers
data-retrieval-services-response-size
data-retrieval-services-timeout
data-retrieval-services-update
dead-site-auto-delete
dead-site-notify-after
dead-site-num-notifications
defaultcontentdb-password
defaultcontentdb-server
defaultcontentdb-user
delete-web-send-email
irmaddinsenabled
irmrmscertserver
irmrmsenabled
irmrmsusead
job-dead-site-delete
job-sqm-timer
job-usage-analysis
job-watson-trigger
large-file-chunk-size
token-timeout
SharePoint virtual server properties:
alerts-enabled
alerts-limited
alerts-maximum
change-log-expiration-enabled
change-log-retention-period
data-retrieval-services-enabled
data-retrieval-services-inherit
data-retrieval-services-oledb-providers
data-retrieval-services-response-size
data-retrieval-services-timeout
data-retrieval-services-update
days-to-show-new-icon
dead-site-auto-delete
dead-site-notify-after
dead-site-num-notifications
defaultquotatemplate
defaulttimezone
delete-web-send-email
job-change-log-expiration
job-dead-site-delete
job-diskquota-warning
job-immediate-alerts
job-recycle-bin-cleanup
job-usage-analysis
job-workflow
max-file-post-size
peoplepicker-onlysearchwithinsitecollection
peoplepicker-searchadcustomquery
peoplepicker-searchadforests
presenceenabled
recycle-bin-cleanup-enabled
recycle-bin-enabled
recycle-bin-retention-period
second-stage-recycle-bin-quota
send-ad-email
