jonsuns7
asked on
Scheduling Jobs on SQL Server
Okay, please bear with me since I am new to SQL Server.
My question is: If I schedule jobs to run on SQL Server (such as backups, loads, etc...) Do I need to keep the application SQL Server Management studio open even though I schedule the jobs to run at odd hours?
The reason I say this is that I had an application that I use to use with an Oracle Database that to my surprise had to remain open and connected to run scheduled jobs. (It was later remedied by the software company.)
Thanks for your input.
My question is: If I schedule jobs to run on SQL Server (such as backups, loads, etc...) Do I need to keep the application SQL Server Management studio open even though I schedule the jobs to run at odd hours?
The reason I say this is that I had an application that I use to use with an Oracle Database that to my surprise had to remain open and connected to run scheduled jobs. (It was later remedied by the software company.)
Thanks for your input.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER