I'm stumpted -- On "http://ola.hallengren.com
" there is a world renound sql maintenance plan - I've run it, it works great, but they have instructions on how to add a Job to your SQL Server DB that I can't figure out.
(Excerpt from site
Execute the stored procedures from SQL Server Agent CmdExec jobs, using sqlcmd and the -b option. Pass the parameters to the stored procedures by name:
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory = 'C:\Backup', @BackupType = 'FULL'" -b
Use SQL Server Agent job output files with tokens for jobid, stepid, date, and time. Output files ensure that you always have a full set of information, in case of an error. Tokens ensure that the output files have unique file names.
How do I run the bolded part??!?
Thanks in Advance!!