Thank you for the feedback.

That kind of mishaps happen to all of us every once in a while 😉

Once again, thank you Dale.

Your advise and refs contained the solution to fix the issue that occured on some of our x64 systems.

Some nasty little virus kept me in bed the last days of last week. :sick:

If you read my script, you'll see a section of the where clause where I added...

Just to add to Lynns reply :

Start with reading these eluminating articles:

- http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/

- http://www.sqlservercentral.com/articles/Advanced+Querying/2829/

- http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/

- http://www.sqlservercentral.com/articles/Advanced+Querying/fourrulesfornulls/1915/

You have to understand NULL means "unkonwn" !

You are inserting an empty string so we...

Is wham_bam a windows group by any chance !

You need a windows user account to be job owner.

It's a petty you didn't post the full sproc.

- Are you reusing cursor names ??

- what happens in sproc EMR.HPSITE.CAREGIVER_SaveLocation ?

Is it also using a cursor ?

...

It actually is a question every mature dba must pose !

- Just to put people back with their feet on the ground.

- to determine if performance may be...

What about sequenced shifts .. should the emp clock out and back in ?

I have elaborated a bit on Dave Ballantynes provided script.

declare @sched table ( EmployeeId int not null,...

How does this system handle night shifts ?

EMP-1 7-10-2009 22:00 ...

- did you grant the needed auth for your service account on the windows folders at the new drive ?

- did you follow the procedure as explained in BOL ?

-...

You need to provide access authority to the new file location(s) to your sqlserver instance service account !

For startup parameters of SQLServer, check out Books Online topic "Starting and Restarting...

Prepare your operation by determining which objects you want in which filegroup.

Just a couple of helping scripts:

http://www.sqlservercentral.com/articles/Administration/64275/

http://www.sqlservercentral.com/scripts/Miscellaneous/31541/

Another forum Q handling about the same subject:

http://www.sqlservercentral.com/Forums/Topic797121-1291-1.aspx

Give me a moment to whipe out a teardrop of nostalgia :alien:

just a couple of helping scripts:

http://www.sqlservercentral.com/articles/Administration/64275/

http://www.sqlservercentral.com/scripts/Miscellaneous/31541/

Maybe this can get you started :

select h.server as Server

, name as Job_Name

, description

, h.run_date as Run_Date

, h.run_time as Run_Time

, h.Run_Status as Run_Status

, h.message

from msdb..sysjobs s

left join

...