Viewing 15 posts - 1,186 through 1,200 (of 1,291 total)
Try this script, and I had no time to check for the accuracy, so take a while and check your data
SELECT DISTINCT JH.[SERVER] SERVER_NAME, SJ.[Name] AS JOBNAME, SJH.STEP_NAME,
SJA.start_execution_date, SJA.stop_execution_date
FROM...
October 30, 2009 at 3:13 pm
I am able to understand your concern, but would like to say that, with your table not having any column for Step Information, how do you want to monitor that...
October 30, 2009 at 2:28 pm
Include the END as the last line in your script to create the Stored Proc
October 30, 2009 at 1:43 pm
Please post the Create Table script for the table which you are using to insert the values and also the error what you are getting for quicker responses
October 30, 2009 at 1:16 pm
goriporvalona (10/30/2009)
You do not have to remove the 2nd HD if it is working.
You need only to replace the non working HD.
The question is which HD broke?? the C...
October 30, 2009 at 12:47 pm
Have you enabled Database mail? If yes then follow the link at Books Online
October 30, 2009 at 12:27 pm
Use this and write something on top of it if needed.
SELECT DISTINCT JH.[SERVER] SERVER_NAME, SJ.[Name] AS JOBNAME,
SJA.start_execution_date, SJA.stop_execution_date
FROM MSDB.dbo.sysjobhistory JH
INNER JOIN MSDB.dbo.sysjobs SJ
ON JH.JOB_ID = SJ.JOB_ID
INNER JOIN MSDB.dbo.sysjobhistory...
October 30, 2009 at 12:15 pm
I tried using my Name Bru Medishetty and it resulted in 2 Forum posts both of them not being mine. One was of another user bruno- and in another one...
October 30, 2009 at 10:08 am
Well, I have never ran into such a situation so I might not have the best possible solution but what I can think is a way to use the available...
October 30, 2009 at 9:27 am
Ok got it..
You know what? The irony is the question was meant to be posted in SQL 2000 and the by mistake the user posted has posted in SQL 2005...
October 30, 2009 at 8:54 am
homebrew01 (10/30/2009)
Bru Medishetty (10/30/2009)
That's useful information. Why do you want to delete it ? Most of the time the question is about getting more history info, not less.
I agree that...
October 30, 2009 at 8:27 am
That's useful information. Why do you want to delete it ? Most of the time the question is about getting more history info, not less.
I agree that is useful Information...
October 30, 2009 at 8:11 am
Steve,
I agree every one has a different view and no two would exactly on similar lines.
But my point here was, the one who started this thread has never come back...
October 30, 2009 at 7:12 am
Hi Abhishek,
As I had promised you Here is the Script, I am sorry if I was late in replying, as it was very late last night by the time I...
October 30, 2009 at 5:38 am
CooLDBA (10/29/2009)
I need the _recordId from Recordset Destination, is there a way that I can put these_recordId in a table, is that possible?
Couldn't Understand what is _recordId? and that too...
October 29, 2009 at 2:29 pm
Viewing 15 posts - 1,186 through 1,200 (of 1,291 total)