I would use an extra step plus this

if dateadd(d,-1,dateadd(m,datediff(m,0,getdate())+1,0))

begin

rsiserror('Last day of month',16,-1)

end

and set the job to on fail mark success on success go to next or something like that.

That is when you track them down and beat them summarily.

Take a look in the Google Groups here http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&safe=active&q=sybase+%22master+device%22+%22DISK+RESIZE%22

Try this for Query C

SELECT viewLLAttr_by_version_a.DataID,

    oQ.[Name],

    viewLLAttr_by_version_a.DefID,

    viewLLAttr_by_version_a.DwgNo,

    viewLLAttr_by_version_a.Sheet,

    viewLLAttr_by_version_a.Version,

    viewLLAttr_by_version_a.Title

FROM

 viewLLAttr_by_version_a

INNER JOIN

 (SELECT iQ.[Name], iQ.DataID, iQ.MaxVersionNum FROM viewDTree_MaxVersion_01 iQ WHERE iQ.[Name] LIKE '%parameter%')...

Run profiler against the server watching for exceptions, logons and logoffs. If the issue isn't with the TCP/IP stack then may be an internal SQL error blowing the connection out.

To test for sure use profiler as I don't have a way to test here.

First and foremost for easier administration on future needs I would create a role to give the permission to then assign the folks or groups to that role. That way...

Are any other packages connecting to an Oracle server and if not then are any other connectig to a SQL Server?

I assmue that would be yes, if so then...

I don't believe you can because the files are marked internally in the sysfiles table and they cannot be rename by hand. However I know you can back them up...

You can invoke a job via sp_start_job which is default to the public role so any account can do it. However if it is running at the time it cannot...

The answer is (at least at this point cause the future can always change) is no.

Ok without knowing the execution plan, the table structure, or indexes the query looks fine as is except maybe the LIKE could be your biggest slow down point.

However this is...

You will run into this http://support.microsoft.com/default.aspx?scid=kb;EN-US;303774 and may potentially have some user accounts not work afterwards (test them afterwards of change). Otherwise I recall nothing else specific unless you set...

Look at your current execution plan, could be index could help or are you meaning is there a faste way to build query itself?

Not understanding your reference can you point me to what you are reading or be a bit more detailed. You can create jobs in SQL to start the moment SQL...