OK, that's a good start. When I run that on one of my servers, it returns the name of a job whose next run date is in the past...

Colin

Could your login and the SQL Agent login be interpreting the data 08/11/2009 differently? If you express it in the form 20091108 then there will be no ambiguity.

John

Jim

You need to use the REPLACE function.

John

Gail, that's fair enough. I suppose what it means is that, since the WHERE clause is being supplied as a parameter to the stored procedure, we could end up...

I wouldn't advise you to do this, for the following reasons:

(1) SQL Injection, as already mentioned by Gail.

(2) Permissions. If all your access to the tables is via stored...

Nobody's going to help you if you won't help yourself. Try writing the code, and post back if there is anything you're struggling with. Having said that, if...

SQLCoder77 (10/4/2010)

---

Here is the approach I am thinking, Get the NextRun DateAndTime and minus the time between Runs to get the last Run and verify a record exists in sysjobactivity....

Yes, because you didn't include the WHERE clause. But even if it says 1000 rows affected, it will still only have actually made any changes to the ones where...

Don't know why it didn't work when I tried to post this script directly, but I've managed to post it as an attachment now. It's the script I use...

I think the REPLACE function should be what you're looking for. Try using that, and post again if you're struggling with it.

John

With the limited information you've provided, then, I would suggest you have a look at what the triggers are doing.

John

What other activity was occurring on the database at the same time? What is the transaction isolation level? Are there any triggers on the table?

John

Sasidhar

Have a play with the File System Task - that should be able to do what you require. You can use variables and expressions to build the names of...

steve block (9/16/2010)

---

One thing I found out is that taking the group NT AUTHORITY\SYSTEM out of the SysAdmin group made it so I could not start a service (Agent or...

Did you follow the link I posted? If so, what don't you understand?