try right clicking on the job, then selecting "View Job History". Then click the check box to "Show step details", then review the step that failed. Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-05-27
1 reads
2003-05-24
1 reads
Here is a example: Step 1: run a DTS job: DTSRun /~Z0xEEE636F80548F73BA5EF00A188020419240846A5997A9C43D83FB3FFFB45BD53333A443666903946F30BA9567E487415C37678474BFDEB13786E3197438AF920742AA740327BBF834A7244374B5F0B900DBE91 Step 2: run a script: set nocount on create table #ftp_script ( script_line varchar(255) not null ) insert #ftp_script values ( 'name' ) insert #ftp_script values ( 'pwdstring' ) insert #ftp_script values ( 'ascii' ) insert #ftp_script values ( 'append C:\temp\Data1 remotePath\Data1.dat' ) […]
2003-05-23
Run one step at a time to find out which step are causing the problem and post the script/SP of that step here see whether we could help out.
2003-05-22
1 reads
I knew about the second link, however it seems to be only discussing ways to get a password for a user account. Once you have a password for an account with the permissions you need then you can simply by pass the stored procedure and do what you want. My answer was focused at the […]
2003-05-22
1 reads
OK, forgot to try that before I posted: You actually have to add -2 or -3 to get the date to flip back to yesterday, at least on my machine. It appears that the time format resolution is around three milliseconds. Couldn't locate anything in SQL BOL to confirm, but I didn't devote hours of […]
2003-05-22
We have tried rebuilding the indexes throughout with a fill factor of 90 (disastrous) and also rebuilding the indexes only on the affected table (77m) rows. Each time we saw degradation from 6 hrs to approx 18 hrs. The database designers have - for reasons unexplained - created this table with 7 (count 'em) non-clustered […]
2003-05-22
The only method I'm aware of is to have a Profiler trace running against your database and capture the events Database\Data File Auto Grow and Database\Log File Auto Grow.
2003-05-20
Ack! Posted before I was finished. The SQL Server Agent account should be a member of the local Administrators group for the autorestart function. I've run into to too many situations where the agent service dies for one reason or another and without the autorestart it can become serious very quick if you rely on […]
2003-05-19
As Andy suggested, you may issue the following query to retrieve the view script, provided that it was created without the ENCRYPTION attribute: SELECT [text] FROM syscomments WHERE OBJECT_NAME([id]) = 'YourViewName'
2003-05-19
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers