But I cannot see some settings of the transfer like source database and destination database in the property window of the task.

The only way I can see that is open...

Thanks all, I reopened the session, this time, I see the manual, it is wierd that yesterday I didn't see the manual window.

Thanks for the help!

How can I set it as a screen saver?

Thanks

I setup to execute a stored procedure when sql server starts up to notifiy me the server is restarted.

It works fine.

My question is what will happen if a stored procedure...

Thanks all, I did some research and made two steps, one is notify SQL server agent restart, the other is to notify SQL server restart.

By the way, anyone knows how...

We use both 2008 and 2008 R2 windows system, and I checked on both systems, the sql job is executed as the SQL service agent account ( the domain user).

I...

see my job in the attachment, it is the same job as yours, it is all executed as the user- the domain user that for sql agent service login. in...

I'm not sure that you completely understand yet. The jobs on a schedule will always run under the "service account" which is the NT SERVICE\SQLSERVERAGENT no matter which domain account...

We do use default installation.

also:

You cannot log into the server with the service account and get access to SQL Server, nor can you impersonate the service account and gain access...

Thanks,

Sorry still confusing:

Quote from SQLKnowitall:

Quote from Jeff:

The service account...

I asked and she says the application support for a arcGis software told her to schedule restart service daily when it is at verison 9.0, she will check if the...

Let me go and find out with the person who set it up initially

The sql run in between is

using waitingfor delay 2 minutes.

I know this can be done through two windows scheduler jobs.

But it seems windows job cannot decide if the previous...

These steps are initally setup by someone else.

For now I wouldn't want to change much about it. I know they can be scheduled to run as a windows scheduler job.

And...

SQLKnowItAll (6/6/2012)

---

it grants the user the proper permissions by assigning it to a "virtual user" within SQL Server. The user itself does not have to have an SQL...