I'd put a new step in job one. Write logic in that step that only calls sp_Startjob for job 2 on the first of the month.

In addition to the question above, have you checked the "errorlog" in the /log folder under SQL Server? That will likely clue you into which files are not available.

BigAl (2/20/2014)

---

Steve: Thanks for the editorial! Amen! Disconnect every now and then! And I agree/have had similar experience as many of the posters here. I've always striven to live close...

No.

You can build this by implementing RBAC (google). Usually someone does a user/group/row implementation where you have a table of users. A table of groups that map rows, and linkages...

Not I. I'd pass on that job. I like my family and bed.

I suspect you've broken something and there is no easy fix. I'd look at migrating the data and schema to a new database, setup as you want things, and then...

Claire,

Please feel free to tackle it. If I don't hear something in about a month, I'll bump this topic.

David.Poole (2/20/2014)

---

A present headache is trying to employ agile methodologies across geographically disperse teams. One of the things about agile is that it encourages all participants to be co-located...

This is usually a networking/routing function.

If users on one zone use a FQDN name and DNS, they just connect without knowing the locations. For example, when I connect to...

Need to see some sample data here. It's not quite clear. Are you saying that if you join the base and linked tables on the part number that checking on...

My kid is studying GIS and starting to learn SQL. He actually had some good questions last night about how to translate some questions into SQL. Neat to see him...

And here I thought you were already insane, Jason.

Congrats

We probably wouldn't include the content because then that defeats some of the purpose of having the site and getting people to interact. Not sure of the value of the...

Ed Wagner (2/17/2014)

---

I noticed...

Jeff Moden (2/18/2014)

---

Steve Jones - SSC Editor (2/18/2014)

---

Jeff Moden (2/16/2014)

---

As I stated peviously, the OP is frequently the worst person to judge answers. You have to remember that they...