No, INSERT statements. Many people won't bother to open a spreadsheet (may contain viruses), and of those that do, most won't have the time or inclination to import all...

Iain

Is it possible that SQL Server (or SQL Server Agent) wasn't running at the time the job was scheduled? Maybe somebody restarted the server, or perhaps if you have...

That makes sense. I usually find it takes about 25 minutes just to set up a restore through the GUI! That's why I always use a script.

John

Andrew

Do you still have the job history going back to when it was taking a long time? If you do, which job steps are showing the biggest improvement?

John

Then your package is not working properly, or maybe the e-mail that you don't get is filtered out by Mimesweeper or whatever you have on your mail system. Perhaps...

Rob

From those results, it looks as if step 2 runs every time the job runs - for the last five executions, certainly. What makes you think step 2 isn't...

Rob

Please run these two queries and post the results:

SELECT

s.step_id

,s.on_success_action

,s.on_success_step_id

,s.on_fail_action

,s.on_fail_step_id

FROM

msdb..sysjobs j

JOIN

msdb..sysjobsteps s

ON

j.job_id = s.job_id

WHERE

j.name = '<Job_Name>'

SELECT TOP (15)

h.step_id

,h.run_date

,h.run_time

,h.run_status

FROM

msdb..sysjobs j

JOIN

msdb..sysjobhistory h

ON

j.job_id = h.job_id

WHERE

j.name = '<Job_Name>'

ORDER BY

run_date DESC

,run_time DESC

John

Rob

Check that the first step not configured to "quit the job reporting success" when it succeeds. You need it to be configured to "go to the next step".

John

Yes, it's usually spelt lakh and is mainly used in India and surrounding countries.

John

600,000 rows in a report? I feel sorry for the person on whose desk that lands! I think some better options include optimising the query for the reports,...

I strongly recommend that you change the Timesheet_Date column to datetime if it is in your power to do so. This will save space in your database and, more...

Maybe the CODEPOINT function will work - something like this:

CODEPOINT(ACCOUNTNAME) == 2 ? "Blank" : ACCOUNTNAME

John

SSIS expression language doesn't allow "CASE", but it does have an equivalent - the "?" operator. Search for "SSIS expression conditional" or something similar and you should find the...

Animal Magic is right. However, doing this is just a kludge. What you should do, if it is in your power, is add a unique constraint on BackOffice(UserID,BackOfficeID)....

Animal Magic (3/29/2012)

---

The question still stands. You are asking for everyone who is in office 711, which both Bob and Robert are.

What are you trying to achieve? Do...