Message Executed as user: sqluser. test test test [SQLSTATE 01000] (Message 0). The step succeeded.that bolded text is your message! ta da!
Thursday, October 3, 2013
SQL Agent Job Logging To Job History Using TSQL
Simple! Use a print statement!
Try it!
In SQL Server Management Studio (SSMS), in Object Explorer, right click the JOBS folder and click NEW JOB
name it TEST
click STEPS on the left hand pane
click the NEW button
name the step TEST STEP
make sure the type is Transact-SQL script(TSQL)
database can be anything, master is fine.
in the big COMMAND box type: Print 'test test test'
click OK twice and run the job
Right click the job and click VIEW HISTORY
click the + to open the list of steps, click on step on and look in the grey pane at the bottom for the details. It will look something like this:
Wednesday, January 23, 2013
eShop WordPress plugin - fix when Shipping Rates aka Shipping Class disappears
It's just a setting, no big deal.
Go to SETTINGS >> eSHOP
Scroll all the way down to the bottom of the page.
--in the section CHECKOUT OPTIONS there are four drop-downs
The drop-down labelled "Minimal checkout form. (this also disables shipping costs)" needs to be set to "NO".
If you set this option to "yes" is takes the Shipping Rates selector off of the page and post edit screens
Subscribe to:
Posts (Atom)