How do I allow users to schedule jobs in Management Studio

Does anyone know how I can grant a non sysdba user who has bulkadmin and dbcreator rights to schedule jobs on databases they've created?

The user is a developer and we dont want to give him sysdba rights.

http://www.sql-server-performance.com//faq/?f=137

how disable MSX server generated job

I have some jobs that when I want to delete or disable it I get bellow error
Msg:
"Error 14274 : cannot add, update, or delete a job that originated from an
MSX server"
what it means? how can I delete this job?
Thanks
TarvirdiIf memory servers, go into the MSDB.dbo.SysJobs table and update the
originating_server column to be that of the name the job currently resides
on. You should then be able to do whatever you want.
"Tarvirdi" wrote:

> I have some jobs that when I want to delete or disable it I get bellow err
or
> Msg:
> "Error 14274 : cannot add, update, or delete a job that originated from an
> MSX server"
> what it means? how can I delete this job?
> Thanks
> Tarvirdi
>
>

how disable MSX server generated job

I have some jobs that when I want to delete or disable it I get bellow error
Msg:
"Error 14274 : cannot add, update, or delete a job that originated from an
MSX server"
what it means? how can I delete this job?
Thanks
TarvirdiIf memory servers, go into the MSDB.dbo.SysJobs table and update the
originating_server column to be that of the name the job currently resides
on. You should then be able to do whatever you want.
"Tarvirdi" wrote:
> I have some jobs that when I want to delete or disable it I get bellow error
> Msg:
> "Error 14274 : cannot add, update, or delete a job that originated from an
> MSX server"
> what it means? how can I delete this job?
> Thanks
> Tarvirdi
>
>

How could I retrieve info about all the jobs using SQL query?

How could I retrieve info about all the jobs using SQL query?
-D
See msdb.dbo.sp_help_job in BOL.
AMB
"D'Animal" wrote:

> How could I retrieve info about all the jobs using SQL query?
> -D
|||Start with:
select * from msdb..SysJobs
From there there is also SysJobSteps, SysJobHistory, etc.
"D'Animal" <D'Animal@.discussions.microsoft.com> wrote in message
news:0AA55366-FC84-46AF-9A3B-C6FEE21D2184@.microsoft.com...
> How could I retrieve info about all the jobs using SQL query?
> -D
|||I got it. Thank you.
-D
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See msdb.dbo.sp_help_job in BOL.
>
> AMB
> "D'Animal" wrote:

How could I retrieve info about all the jobs using SQL query?

How could I retrieve info about all the jobs using SQL query?
-DSee msdb.dbo.sp_help_job in BOL.
AMB
"D'Animal" wrote:

> How could I retrieve info about all the jobs using SQL query?
> -D|||Start with:
select * from msdb..SysJobs
From there there is also SysJobSteps, SysJobHistory, etc.
"D'Animal" <D'Animal@.discussions.microsoft.com> wrote in message
news:0AA55366-FC84-46AF-9A3B-C6FEE21D2184@.microsoft.com...
> How could I retrieve info about all the jobs using SQL query?
> -D|||I got it. Thank you.
-D
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See msdb.dbo.sp_help_job in BOL.
>
> AMB
> "D'Animal" wrote:
>

How could I retrieve info about all the jobs using SQL query?

How could I retrieve info about all the jobs using SQL query?
-DSee msdb.dbo.sp_help_job in BOL.
AMB
"D'Animal" wrote:
> How could I retrieve info about all the jobs using SQL query?
> -D|||Start with:
select * from msdb..SysJobs
From there there is also SysJobSteps, SysJobHistory, etc.
"D'Animal" <D'Animal@.discussions.microsoft.com> wrote in message
news:0AA55366-FC84-46AF-9A3B-C6FEE21D2184@.microsoft.com...
> How could I retrieve info about all the jobs using SQL query?
> -D|||I got it. Thank you.
-D
"Alejandro Mesa" wrote:
> See msdb.dbo.sp_help_job in BOL.
>
> AMB
> "D'Animal" wrote:
> > How could I retrieve info about all the jobs using SQL query?
> >
> > -Dsql

How check the results of the SQL Backups on serveral servers

Hi, I'm looking for a simple an easy solution to check the sqlserver backups
,
every day we run some backups jobs in diferent servers. How i can verify the
backup jobs everyday without check the enterprise manager of ervery server?
Is posible create a report where the copys are succesfuly per server and per
sql server database?
Thanks in advance
Fernando... Or use xp_smtp_sendmail and remove xp_sendmail and create a version of
xp_sendmail which in turn
calls xp_smtp_sendmail. As described on www.sqldev.net.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:092001c490db$294323c0$a401280a@.phx.gbl...[vbcol=seagreen]
> You could get SQL Server Agent to email you results of the
> backup, but that is dependant upon SQL Agent having a
> domain user id with a mailbox.
> Thanks
> Peter
> "There is no such thing as public opinion. There is only
> published opinion."
> Winston Churchill
>
> the sqlserver backups,
> How i can verify the
> of ervery server?
> per server and per

How check the results of the SQL Backups on serveral servers

Hi, I'm looking for a simple an easy solution to check the sqlserver backups,
every day we run some backups jobs in diferent servers. How i can verify the
backup jobs everyday without check the enterprise manager of ervery server?
Is posible create a report where the copys are succesfuly per server and per
sql server database?
Thanks in advance
FernandoYou could get SQL Server Agent to email you results of the
backup, but that is dependant upon SQL Agent having a
domain user id with a mailbox.
Thanks
Peter
"There is no such thing as public opinion. There is only
published opinion."
Winston Churchill
>--Original Message--
>Hi, I'm looking for a simple an easy solution to check
the sqlserver backups,
>every day we run some backups jobs in diferent servers.
How i can verify the
>backup jobs everyday without check the enterprise manager
of ervery server?
>Is posible create a report where the copys are succesfuly
per server and per
>sql server database?
>Thanks in advance
>Fernando
>.
>|||... Or use xp_smtp_sendmail and remove xp_sendmail and create a version of xp_sendmail which in turn
calls xp_smtp_sendmail. As described on www.sqldev.net.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:092001c490db$294323c0$a401280a@.phx.gbl...
> You could get SQL Server Agent to email you results of the
> backup, but that is dependant upon SQL Agent having a
> domain user id with a mailbox.
> Thanks
> Peter
> "There is no such thing as public opinion. There is only
> published opinion."
> Winston Churchill
>
> >--Original Message--
> >Hi, I'm looking for a simple an easy solution to check
> the sqlserver backups,
> >every day we run some backups jobs in diferent servers.
> How i can verify the
> >backup jobs everyday without check the enterprise manager
> of ervery server?
> >Is posible create a report where the copys are succesfuly
> per server and per
> >sql server database?
> >
> >Thanks in advance
> >Fernando
> >.
> >

How check the results of the SQL Backups on serveral servers

Hi, I'm looking for a simple an easy solution to check the sqlserver backups,
every day we run some backups jobs in diferent servers. How i can verify the
backup jobs everyday without check the enterprise manager of ervery server?
Is posible create a report where the copys are succesfuly per server and per
sql server database?
Thanks in advance
Fernando
... Or use xp_smtp_sendmail and remove xp_sendmail and create a version of xp_sendmail which in turn
calls xp_smtp_sendmail. As described on www.sqldev.net.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:092001c490db$294323c0$a401280a@.phx.gbl...[vbcol=seagreen]
> You could get SQL Server Agent to email you results of the
> backup, but that is dependant upon SQL Agent having a
> domain user id with a mailbox.
> Thanks
> Peter
> "There is no such thing as public opinion. There is only
> published opinion."
> Winston Churchill
>
> the sqlserver backups,
> How i can verify the
> of ervery server?
> per server and per