THEN ( AVG(FLOOR(run_duration / 100)) ) + 10 If job average less than 5 minutes then limit is avg+10 minutes NOT NULL ,Īct.start_execution_date AS StartExecutionDate ,ĪVG(FLOOR(run_duration / 100)) AS AvgDurationMin , ) - 0 = Not idle or suspended, 1 = Executing, 2 = Waiting For Thread, 3 = Between Retries, 4 = Idle, 5 = Suspended,, 7 = PerformingCompletionActions Request_source_id SYSNAME COLLATE database_default Create intermediate work tables for currently running jobs SET = 150 -Use whole percentages greater than 100 else the time limit is simply average + 10 minutes NOTE: Percentage limit is applied to all jobs where average runtime greater than 5 minutes Set limit in minutes (applies to all jobs) Beware, uses undocumented stored procedure xp_sqlagent_enum_jobsĪdded commented line for testing purposes (avg+1 minute for short tests) Updated code to deal with “phantom” jobs that weren’t really running. =Ĭhanged Method for capturing currently running jobs to use _sqlagent_enum_jobs 1, '' alerts admins if runtime passes set threshold Description: Monitors currently running SQL Agent jobs and Here's why attempt #2397 to make for profit healthcare work wil finally work ( thehill.I have been using the following stored proc on a SQL agent job: - = It's November, and Huffington Post once again is already trying to take a big steaming downer dump all over your Thanksgiving dinner table ( ) » (16 comments) Welcome to a happy ending on Caturday ( ) » (476 comments) Along with your katanas ( ) » (10 comments) Let's lift a glass of Red Red Wine in honor of Astro of UB40 ( msn.com ) » (1 comment)Įver forget your umbrella while leaving the house? Make a rack to hold it on the inside of your front door. Pardon me as I perambulate as though it were 1908 ( ) » (0 comments) No, wait, that's actually News, because they lost their previous 20 football games ( ) » (4 comments)Ĭhick-fil-A, based upon a failure to embrace the present and future, may become a thing of the past ( ) » (14 comments) Not News: The Arizona Wildcats have won a football game. Great read.anything historical would be so appreciated ( ) » (21 comments) Any advice? Just finished Troy by Stephen Fry. Astroworld crowd surge investigation has taken a turn for the surreal ( ) » (27 comments)
0 kommentar(er)
