Viewing 13 posts - 61 through 73 (of 73 total)
If you're using Enterprise Manager you can do this as well.. there is a check-box "check existing data on creation". Un-check it and you should be able to create the...
February 6, 2004 at 6:45 am
We run multiple jobs at a time.. normally without incident. One thing to watch for is if you have more than one job that accesses the same table then there could be locking...
January 14, 2004 at 6:50 am
Check to make sure that the account that the SQL Agent is set up to use has the System Administrator server role checked. When you are running the job manually...
January 14, 2004 at 6:39 am
I like your new .Net version... keep up the good work!
January 13, 2004 at 8:05 am
The manner that DTS packages are saved changed between service packs in SQL Server 7 as well as 2000. If the package was saved with a later version then upgrade...
January 8, 2004 at 6:59 am
Here's a good article from Microsoft about error handling within stored procedures: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00f15.asp
December 10, 2003 at 7:33 am
I found the job scheduling security very confusing when I was first starting out. To make it work make sure you are logged in with a user id that...
December 5, 2003 at 12:54 pm
alternatively, just specify the times as well..
select top 10 *
from fact_ins_booking
where date_key between '2002-10-16 00:00:00'
and '2002-10-25 23:59:59'
Edited by - amackay_1 on 12/02/2003 05:28:38 AM
December 2, 2003 at 5:28 am
Alternatively.. instead of within ASP code, embed ASP parts within html. A bit less efficient but easier to read in my opinion:
<TD><a href="editScheduleItem.asp?Submit1=<%=fldvalue%>"><%=fldvalue)%></a></TD>
November 20, 2003 at 6:00 am
Do you mean Windows 2000 Professional or Server? My understanding is that it can't run on 2000 Professional.
Edited by - amackay_1 on 11/18/2003 08:09:52 AM
November 18, 2003 at 7:57 am
Carl, I had the same problem and I seemed to solve the issue by making sure that a user is logged into the SQL Server (ie. logged into Windows). ...
June 10, 2003 at 11:07 am
Yes, the owner of the job is already the same as the SQL Server Agent startup account.
April 11, 2003 at 10:00 am
Actually, I have 2 different jobs I'm testing.. one sends SQL mail, the other doesn't. Both fail in the manner I described.
Edited by - amackay_1 on 04/11/2003 08:59:26...
April 11, 2003 at 8:56 am
Viewing 13 posts - 61 through 73 (of 73 total)