Viewing 15 posts - 8,206 through 8,220 (of 26,490 total)
Erin Ramsay (4/1/2013)
AndrewSQLDBA (4/1/2013)
SQL Server does not Loop thru rows. SQL Server is Set Based.Please do not indicate that a database loops thru rows.
Andrew SQLDBA
🙂
Give me a set based statement...
April 1, 2013 at 10:52 am
ScottPletcher (3/26/2013)
sp_MSforeachdb is indeed a cursor, and not a particularly good one.Still, it exists, and it's useful for quick-and-dirty tasks sometimes, particularly if you don't have a lot of dbs.
...
And...
April 1, 2013 at 10:33 am
I know you don't want to see or hear from me but here is an alternative solution to yours:
SELECT
j.name,
msdb.dbo.Agent_datetime(h.run_date, h.run_time) AS Run_Datetime,
...
April 1, 2013 at 10:29 am
Sean Lange (4/1/2013)
Grant Fritchey (4/1/2013)
Lynn Pettis (3/31/2013)
Yes, I am sure about doing this, but I am both anxious and excited about going. It may not be the safest place...
April 1, 2013 at 7:58 am
Welsh Corgi (4/1/2013)
SELECT DISTINCT j.Name ...
April 1, 2013 at 7:09 am
bryan van ritter (3/31/2013)
solved the problem myselve.bryan
Great! That is good news. Now, forum etiquette would have you post your solution as it may benefit others with a similar problem...
March 31, 2013 at 3:43 pm
Try this:
SELECT
j.job_id,
s.srvname,
j.name,
js.step_id,
js.command,
j.enabled ,
...
March 31, 2013 at 2:54 pm
Check your msdb data for last_run_date and last_run_time values of 0.
March 31, 2013 at 2:52 pm
Interesting. I drop and recreate my job then run the script I provided (sans the WHERE clause) without running the job first and I get the error message you...
March 31, 2013 at 2:49 pm
USE [msdb]
GO
/****** Object: Job [TestJob] Script Date: 3/31/2013 2:42:38 PM ******/
EXEC msdb.dbo.sp_delete_job @job_id=N'775a2b1e-52c1-4d6f-b661-1bba00e0af47', @delete_unused_schedule=1
GO
/****** Object: Job [TestJob] Script Date: 3/31/2013 2:42:38 PM...
March 31, 2013 at 2:43 pm
Welsh Corgi (3/31/2013)
Lynn Pettis (3/31/2013)
Welsh Corgi (3/31/2013)
Welsh Corgi (3/31/2013)
Lynn Pettis (3/31/2013)
SELECT
j.job_id,
s.srvname,
j.name,
...
March 31, 2013 at 1:59 pm
Welsh Corgi (3/31/2013)
Welsh Corgi (3/31/2013)
Lynn Pettis (3/31/2013)
SELECT
j.job_id,
s.srvname,
j.name,
js.step_id,
...
March 31, 2013 at 1:50 pm
I just did a copy/paste/execute of the code I posted in a new SSMS query window, no problems.
March 31, 2013 at 1:39 pm
Welsh Corgi (3/31/2013)
Lynn Pettis (3/31/2013)
SELECT
j.job_id,
s.srvname,
j.name,
js.step_id,
js.command,
...
March 31, 2013 at 1:37 pm
Perhaps something more like this:
SELECT
j.job_id,
s.srvname,
j.name,
js.step_id,
js.command,
j.enabled ,
...
March 31, 2013 at 1:28 pm
Viewing 15 posts - 8,206 through 8,220 (of 26,490 total)