list MS SQL weekly job

yes, sql server jobs (sql agent) can do that, no "script" needed.
not available in the SQL Express version, though, in which case you use the OS scheduler + sqlcmd tool

noo, I mean I just want a list of job that run weekly and monthly,

how ?

Vikas Garg,

I don't get it:

That query return no SQL job name for me.

Guy Hengel [angelIII / a3],

What is the query to show this out ?  select * from dbo.sysschedules; will gives errors.

>select * from dbo.sysschedules; will gives errors.
you need to be in the msdb database:

use msdb
go
select * from dbo.sysschedules;

Select allOpen in new window

apart from that: which error

but it just show the schedule name, it don't show the SQL job name, how come ?