Viewing 15 posts - 1 through 15 (of 38 total)
Try this,
It will tell you the current status and last Execution and future execution times.
USE [msdb]
sp_help_job
January 2, 2014 at 11:47 am
WolfgangE (9/14/2013)
for adding the jobs i guess that this special procedure updates the user databases too. As on a secondary the databases of the availability group are write protected i...
September 16, 2013 at 7:06 am
I have doubt whether it is going away.
If you read the Documentation (for Hekaton CTP1)released in June 2013, by Kalen Delaney, she mentions that In-memory OLTP components will always...
August 6, 2013 at 12:56 pm
curious_sqldba (5/17/2013)
May 20, 2013 at 9:52 am
A great article that could be added to this behavior is from Erland SommarsKog. Also as John mentioned, the above query may have been added by developers to avoid Parameter...
April 8, 2013 at 12:06 pm
Yeah you guys are right; Our dev's coded that and now since I was playing around with 2012 instance, I have to fix their codes.
Hopefully it is just in one...
April 5, 2012 at 2:34 pm
Never Mind about the second problem.. I mistakenly clicked the Restore with NO RECOVERY option. Its a drop down now (No radio buttons) and i was kindoff browsing the GUI.
But...
February 24, 2012 at 3:05 pm
Yes I did that as well; This was the first step i did in troubleshooting. The SSMS has Administrator in brackets at the top of my window.
Also i noticed...
February 24, 2012 at 12:58 pm
Both the solutions work; Thanks for the help,
@cadavre: It does not matter how you have represented the solution in each individual groups. i have more work to do...
January 24, 2012 at 11:48 am
The only way I was able to solve the problem is to analyze each and every case in the following scenario and use CASE statements to calculate the minutes ...
January 24, 2012 at 7:57 am
Sorry about the confusion. I wish I had the rights to take down a POST ( of course posted by Me)!
January 20, 2012 at 9:18 am
bwoulfe (12/20/2011)
Have you verified that though? Did you do a select without the column_name to see what was returned?SELECT *
FROM INFORMATION_SCHEMA.COLUMNS c
WHERE TABLE_NAME = 'Stores'
@bwolfe : yes the Select...
December 20, 2011 at 12:11 pm
I am pretty sure that we have only one Stores table; Also adding the Table_Schema did not help. The SQL analyzer is trying to look up for the...
December 20, 2011 at 10:12 am
I think i made a mistake when I posted the resultant set, Also it was because i was trying to reproduce the real world scenario in test data. I think...
October 11, 2011 at 9:27 am
O..o It would have been incredibly simple if i had to return just the min and max on year.:-P
Actually I am behind the values of MAX and MIN per...
October 6, 2011 at 9:22 am
Viewing 15 posts - 1 through 15 (of 38 total)