User profile for PDinCA

Thanks, Chris. Will test it out once released. Cheers. / comments

Thanks, Chris. Will test it out once released. Cheers.

0 votes

Shared on all databases. Thanks, Chris. / comments

Shared on all databases. Thanks, Chris.

0 votes

Thanks, Chris. To which of the original problems are you referring - I assume #1. Have you looked at the "escape behavior problem" reported as Problem #2? / comments

Thanks, Chris. To which of the original problems are you referring - I assume #1. Have you looked at the "escape behavior problem" reported as Problem #2?

0 votes

Any update on this issue, please...? I'll live with the fake-blue-dots as I'm the only DB developer, but it is rather confusing to see. / comments

Any update on this issue, please...? I'll live with the fake-blue-dots as I'm the only DB developer, but it is rather confusing to see.

0 votes

This is NOT limited to TFS I have the persistently misleading blue dots with SVN. / comments

This is NOT limited to TFS I have the persistently misleading blue dots with SVN.

0 votes

Thanks for the Uservoice URL, Brian, I added to the very similar suggestion titled, "specify a time in which jobs should be finished by" at http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2708577-specify-a-time-in-which-jobs-should-be-finished-by Would you please post the RSS URL for the SSC Uservoice as I like to keep an eye on suggestions that way (I already have the SQL Prompt, SSC and Search RSS feeds active). Thanks. / comments

Thanks for the Uservoice URL, Brian, I added to the very similar suggestion titled, "specify a time in which jobs should be finished by" at http://sqlmonitor.uservoice.com/forums/91743-suggestions/...

0 votes

As there's no Uservoice (that I can see), could I register this post as an Enhancement Request? As it is, I can use the above for ONE Job per Custom Alert, which is fine if that's all one cared about, up to a handful perhaps would be OK, but in environments with many servers and many, many Jobs, I can see this kind of thing being unwieldy in a hurry. Would RG please consider adding a standard alert "Job Still Running"? It should be reusable by being able to select the job of interest and state the job duration that when exceeded would raise the alert. Alert thresholds could use the standard Low/Medium/High measures for "Duration in excess of the Alert Duration", perhaps. Thanks in hopes. / comments

As there's no Uservoice (that I can see), could I register this post as an Enhancement Request? As it is, I can use the above for ONE Job per Custom Alert, which is fine if that's all one cared abo...

0 votes

Helps IMMENSELY. Many thanks, Brian. UPDATE Sadly, the join criterion on just job_id gets me the list of every execution, so I revised the query, using my own replacement for DATEDIFF() for the hours calc as I want to be precise, not just have it fire after 3hrs 1min if it starts at, say, 12:59... (Hate DATEDIFF!) Using SELECT TOP 1 ... ORDER BY a.start_execution_date DESC gets me the currently executing Job details. /* Get the JobID for MyJob */ DECLARE @JobId uniqueidentifier SELECT @JobId = job_id FROM msdb..sysjobs WHERE name = '_Quarter Hourly Update Aggregation' /* Define a temp table to hold xp_sqlagent_enum_jobs This xp will tell us which jobs are running */ DECLARE @ExecutionStatus TABLE ( JobID uniqueidentifier PRIMARY KEY -- Job ID , LastRunDate int , LastRunTime int -- Last run date and time , NextRunDate int , NextRunTime int -- Next run date and time , NextRunScheduleID int -- an internal schedule id , RequestedToRun int , RequestSource int , RequestSourceID varchar(128) , running int -- 0 or 1, 1 means the job is executing , CurrentStep int -- which step is running , CurrentRetryAttempt int -- retry attempt , JobState int ----0 = Not idle or suspended, 1 = Executing, 2 = Waiting For Thread, 3 = Between Retries, 4 = Idle, 5 = Suspended, [6 = WaitingForStepToFinish], 7 = PerformingCompletionActions ) INSERT @ExecutionStatus EXEC xp_sqlagent_enum_jobs 1 , '' , @JobId /* Get the number of hours the has been running, if it is running */ SELECT TOP 1 DBA.dbo.udf_GetElapsedHours(a.start_execution_date, GETDATE()) AS RunningHours FROM msdb..sysjobactivity a INNER JOIN @ExecutionStatus s ON s.JobId = a.job_id WHERE s.running = 1 ORDER BY a.start_execution_date DESC Thanks, though, for your original query - wouldn't be anywhere without it. 8) / comments

Helps IMMENSELY. Many thanks, Brian.UPDATE Sadly, the join criterion on just job_id gets me the list of every execution, so I revised the query, using my own replacement for DATEDIFF() for the hour...

0 votes

Withdrawn! Jury's out on the patch - server ground to a halt. Rebooting... UPDATE - ERROR EXCEPTIONS BEING THROW Event Type: Error Event Source: SQL Source Control 3 Event Category: None Event ID: 32 Date: 10/26/2012 Time: 2:13:08 PM User: N/A Computer: XCOUTSIDE1 Description: ng.ErrorReporterBase #6:Not reporting error RedGate.Shared.Utils.OperationCancelledException: Exception of type 'RedGate.Shared.Utils.OperationCancelledException' was thrown. at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationStatusConvenienceOverloadsBase.CancelIfCancelled() at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke() at #eEc.#Qlg.Invoke() at #JLc.#PLc.#Jfb.#EJf() at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean ) Followed 13 seconds later when changing to another DB Event Type: Error Event Source: SQL Source Control 3 Event Category: None Event ID: 32 Date: 10/26/2012 Time: 2:13:21 PM User: N/A Computer: XCOUTSIDE1 Description: ng.ErrorReporterBase ConfigurableThreadPool thread:Not reporting error RedGate.Shared.Utils.OperationCancelledException: Exception of type 'RedGate.Shared.Utils.OperationCancelledException' was thrown. at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#uz2b(String , IDatabaseConnection , #1heb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action ) at #qlhb.#0heb.#wieb(#L3c , #ZZ7 , #A57 , IDatabasePollingManager , IObjectExplorerStateService , #82Vc , #32Vc , #4Ec , #j3l , Options , #quBb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action ) at #GWeb.#VXM.#mYM[#NrPb](Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action ) at #GWeb.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector ) at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector ) at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus ) at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f() at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action) at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke() at #GWeb.#4Ec.#eqzc(ICancellableOperation`1 ) at #GWeb.#4Ec.#OUe.#hqzc() at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean ) / comments

Withdrawn! Jury's out on the patch - server ground to a halt. Rebooting...UPDATE - ERROR EXCEPTIONS BEING THROW Event Type: Error Event Source: SQL Source Control 3 Event Category: None Event ID:...

0 votes

Matt_B wrote: ...so I'm back to SSMS 2008 except when I need to work on a 2012 server. Hi Matt, I'm intrigued by your phrase quoted above. I have three SQL2012 boxes, 2 on "my" domain and another hosted at Rackspace on their domain, and I do everything I've needed so far with the exception of the Integration Services Catalog maintenance from a SQL2008R2 SSMS. Just wondering what it is that necessitates you jumping onto the 2012 box itself so I can be prepared for that rather than emit a long grrrrr. Cheers! / comments

Matt_B wrote: ...so I'm back to SSMS 2008 except when I need to work on a 2012 server. Hi Matt, I'm intrigued by your phrase quoted above. I have three SQL2012 boxes, 2 on "my" domain and anot...

0 votes

How can we help you today?

PDinCA

Comments