Task will not run

[Kathy Kiley]

HELP! I'm a newbie. Our SQL person left and I've been thrown into the fire.
The task below will not run on one database, but works fine on another. Can anyone help? Also if anyone can tell me what it's actually supposed to do, that would be great too. I've tried using the Database Maintenance Plan Wizard to set up new tasks, but cannot seem to recreate this code, so I don't understand the purpose of the task. Please help.

SQLMAINT.EXE -D VHR_DATASQL -CkDBNoIdx -CkAlNoIdx -BkUpLog C:SQL65BACKUP -BkUpMedia DISK -Rpt C:SQL65LOGVHR_DATASQL_maint.rpt -To Jon McDonald

[Patrick Fediere]

Hi, Kathy,

1° You will find a complete description of the SQLMAINT utility in the Books onLine. More complete than I cld do there.

2° At the end of the parameters you have the "-TO" parameter. It's for send the result by mail to the person named. Is this guy still in the list of valid users? Remove the "-TO" parameter the result is in the file.

3° Don't worry

Regards
Patrick

On 12/30/98 10:16:27 AM, Kathy Kiley wrote:
> HELP! I'm a newbie. Our SQL person left and I've been thrown into
> the fire.
The task below will not run on one database, but works fine on
> another. Can anyone help? Also if anyone can tell me what it's
> actually supposed to do, that would be great too. I've tried using the
> Database Maintenance Plan Wizard to set up new tasks, but cannot seem to
> recreate this code, so I don't understand the purpose of the task.
> Please help.

SQLMAINT.EXE -D VHR_DATASQL -CkDBNoIdx -CkAlNoIdx -BkUpLog
> C:SQL65BACKUP -BkUpMedia DISK -Rpt C:SQL65LOGVHR_DATASQL_maint.rpt -To
> Jon McDonald

[Kathy Kiley]

Hi Patrick! Thanks for replying so quickly. Yes, Jon McDonald is still in the list of users. He is my supervisor, all sqlmail messages are sent to him, but it is my responsiblity to figure out why things aren't working. Thanks, I'll check out books on-line. Wish me luck.

On 12/30/98 10:54:45 AM, Patrick Fediere wrote:
> Hi, Kathy,

1° You will find a complete description of the SQLMAINT
> utility in the Books onLine. More complete than I cld do there.

2° At
> the end of the parameters you have the "-TO" parameter. It's
> for send the result by mail to the person named. Is this guy still in the
> list of valid users? Remove the "-TO" parameter the result is in
> the file.

3° Don't worry

Regards
Patrick

On 12/30/98 10:16:27
> AM, Kathy Kiley wrote:
> HELP! I'm a newbie. Our SQL person left
> and I've been thrown into
> the fire.
The task below will not run
> on one database, but works fine on
> another. Can anyone help? Also if
> anyone can tell me what it's
> actually supposed to do, that would be
> great too. I've tried using the
> Database Maintenance Plan Wizard
> to set up new tasks, but cannot seem to
> recreate this code, so I
> don't understand the purpose of the task.
> Please
> help.

SQLMAINT.EXE -D VHR_DATASQL -CkDBNoIdx -CkAlNoIdx -BkUpLog
>
> C:SQL65BACKUP -BkUpMedia DISK -Rpt C:SQL65LOGVHR_DATASQL_maint.rpt -To
>
> Jon McDonald